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

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

 

[Marshall Barton]

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.

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.