Grouping by week 2

[ttusoccer]

Currently I have a report that is first grouped by our customer and then grouped by date. I also have a macro set up so I can choose a start date and a end date for my report. The problem is when I run the report it is putting my total for all info at the end of the report. I would like to have a total at the end of each week. We run our weeks from Sunday to Sat. If I run a 2 week period how would I get a total for the weeks data but keep the report running and then give me a total for the second week? Currently I will get one big total of all the 2 weeks. One side note, I do have a total set up in the report for each day.

 

[rjoubert]

Click on your "Sorting and Grouping" button, and in the group for your date, select "Week" from the "Group On" field. Note, I am using Access 2003...I'm not sure if this is available in previous versions of Acess.

 

[ttusoccer]

I have tried that but then it list all transactions for the week. Then, the date that is listed at the top of the report is not the first day of the week. Is there a way to still have it total on each day and total on the week. For Example:

Customer
7-30-06
Details
Total
7-31-06
Details
Total
8-1-06
Details
Total
8-2-06
Details
Total
8-3-06
Details
Total
8-4-06
Details
Total
8-5-06
Details
Total
Week Total
8-6-06
Details
Total
And so on....
With a total of all on the bottom of the report.
What do you think?

 

[rjoubert]

Group by Customer, then by Date (group on week), then group by Date again (show header/footer).

In the last group, display your date and total for the day...don't display anything in the detail section.

 

[ttusoccer]

Worked Great! Thanks for the help.