Hello All! I need some help with building a report in Microsoft Access. Here is the scenario...
I have a table that stores sales data for retail outlets in four separate regions. Each store updates their sales data in the table. I need to genereate a report compiling all the individual store data onto one usable report.
The table format will be each store listed individually with a total for the region at the bottom of the report.
Easy enough. I have that part done.
The part that is turning me gray is this: I need to be able to pull LAST WEEK'S TOTALS (totals only) for a week over week comparison.
I am able to create two separate queries to handle this task (Q1 pulls the individual stores data for this week and Q2 pulls the Regional Totals for the previous week), but I can not figure out how to generate one report from these two queries.
Any help would be greatly appreciated.
I have a table that stores sales data for retail outlets in four separate regions. Each store updates their sales data in the table. I need to genereate a report compiling all the individual store data onto one usable report.
The table format will be each store listed individually with a total for the region at the bottom of the report.
Easy enough. I have that part done.
The part that is turning me gray is this: I need to be able to pull LAST WEEK'S TOTALS (totals only) for a week over week comparison.
I am able to create two separate queries to handle this task (Q1 pulls the individual stores data for this week and Q2 pulls the Regional Totals for the previous week), but I can not figure out how to generate one report from these two queries.
Any help would be greatly appreciated.