Group report by Weeks?

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

I need to group a report by weeks. The beginning of the week would be
Sunday and the end of the week would be Saturday.

How can I do this so it shows a grouping from Sunday to Saturday with
the dates for those days?

I can do a query and get the totals of hours for class attendance no
problem but I do not need it by day I need it by the above weeks.

Thanks for any help.
 
You should be able to set the sorting and grouping dialog to your date field
and then selecting Group On of Week.
 
How can I get the report to group though by a Sunday Date Through a
Saturday Date and show those dates in the group part of the report?
 
Did you try set the sorting and grouping like I suggested?
You can find the Sunday date by using an expression like:
=DateAdd("D",-Weekday([DateField])+1,[DateField])
 
Duane the last suggestion worked for what I need. Thanks alot.

Worked perfect now I can get the beginning of the week date, and then
end of the week date for the report.

Great...............................

Just for information I am working on a training attendance program and
that helped to finalize it.
 
Back
Top