week grouping start on Saturday

[Liz]

Hi,

I'm creating a report where I've grouped the workdate by
week, but I want to start the week from Saturday to
Friday. Right now the week starts from Sunday to Saturday.
Could you should me how to do that?

Thanks!
Liz

 

[Ken Snell]

How have you set up your grouping?

 

[Allen Browne]

The Weekday() function lets you specify the weekday that starts the week,
e.g.:
Date() - Weekday(Date(), vbSaturday) + 1

In the context of a query or the Control Source of a text box, use 7 instead
of the constant vbSaturday.