You need to add a calculation field that returns a common value for records of the same week, for example =
AttendanceDate - DayofWeek ( AttendanceDate )
and summarize your report by this field.
Note:1. You don't really need a DayName field - you can format the attendance date itself to show the day name;
2. Similarly, if you set the above calculation's result to type Date and add + 2 to the formula, it will return the Monday of the week - you can then use it also as a label for the summarized period.
Thanks for the help. This was exactly what I needed. I'm still a little unclear on exactly how the calculation works, but I have a copy of "The Missing Manual" and I'm going to start reading up on date calculations. In the meantime, thanks to you, I've got my report exactly the way I need it.
I'm off to see if I can figure out how to get monthly figures by myself. I really appreciate your super-fast help.
You can usually understand how date calculations work if you think of them as number fields that count the number of days from an early arbitrary date.
Datefield + 5, for example returns a date 5 days later than the date stored in "datefield".
Thanks PhilModJunk. I understand your example because it's pretty straightforward. But I'm obviously looking at this the wrong way, because in the example given above I read the calculation as "AttendanceDate minus the day of the week of the AttendanceDate". That would be the same as saying "August 1, 2009 minus Saturday". Again, obviously, that's not what it means, because it does exactly what it's supposed to by letting me produce a weekly report.
That would be the same as saying "August 1, 2009 minus Saturday".
Almost, but not quite. It's actually "August 1, 2009 minus 7", because DayOfWeek() returns a number, and the number for Saturday is 7.
date - DayofWeek ( date )
returns the 0th day of the week in which date falls.