Group report by Weeks?

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.
 
D

Duane Hookom

You should be able to set the sorting and grouping dialog to your date field
and then selecting Group On of Week.
 
R

Randy

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?
 
D

Duane Hookom

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])
 
R

Randy

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.
 
Top