How do I get Access to group using Sunday as the end of the week?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to group data into weeks on a report, using Sunday as the end of the
week. Access is using Saturday, when I group by "week" as the grouping
level. Does anybody know how to change this?
 
Dogger said:
I want to group data into weeks on a report, using Sunday as the end of the
week. Access is using Saturday, when I group by "week" as the grouping
level.
Click to expand...


Scrap the week option and instead of grouping on the date
field, group on this expression:

=DatePart("ww", datefield, 2)

Check Help to make sure you understand how DatePart works.
 
Back
Top