I am fairly new to Access. I've been given a report to create that has me stumped. I have a table that is used to collect "snapshots" of statistics regarding employment counts at a variety of customers' sites. Each month, the table is updated with current counts, and this provides an ongoing history. My table has the following information: Client ID, number of full-time staff, number of part-time staff, date. The report I have to create is supposed to show the counts for each client for the current month compared to the prior month; the current month compared to the previous year-end (which is March 31st) and the current month compared to the count a year ago. All this on the same page along with variance calculations. The report is supposed to have the following format: Client ID, Client Name, Current Month, Prior Month, Variance, Current Month, Year End, variance, Current Month, Last Year, variance. There are about 100 clients.
I have no idea where to start! A summary report will not work, and a detail report doesn't give me the information that I need in the format that has been requested. Can you help?!