week grouping start on Saturday

  • Thread starter Thread starter Liz
  • Start date Start date
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
 
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.
 
Back
Top