week grouping start on Saturday

L

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
 
A

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