Set Query Criteria to upcoming Saturday

[twalsh]

Designing a Query in Design Mode

Field is called 'SCH_WK' or Schedule Week, which we identify as the Saturday
for each week.

I need to run the query each day and want the SCH_WK criteria to update to
the next saturday.

what syntax would i use, i have tried several options but keep ending up at
a dead end...

 

[Allen Browne]

Try:
Date() - Weekday(Date()) + 7

 

[twalsh]

Thanks Mr. Browne!

Try:
Date() - Weekday(Date()) + 7