I'm a novice at Access, and mostly self-taught. I work in the management office for a local small grocery store chain that unfortunately has a high turnover rate. My employer would like me to create a report that shows the monthly turnover by store. I know it is possible, but I am at a loss as to how to begin. I know there will likely be many queries involved.
The final report should look like this:
Store
Month
Total Employees at the Start of the Month, Total Employees at the End of the Month, Net Change
Next Month.... etc.
Next Store... etc.
The table that stores the information has the following fields that will have to be used: (I tried to do a screenshot of my table in design view but couldn't figure out how to paste it here. The info after the colon is the data type)
Emp_ID: Number
Emp_Name: Text
Store: Number (look-up field that connects the store number to the store name)
Date of Hire: Date
Date of Resignation/Termination: Date
I've contemplated creating tons of queries calculating the number of employees lost and gained during each month for each store and using that data to create multiple sub-reports to create the final report, but I cannot help but think that there has got to be an easier way! Please help