Query show all appointments for current week 1

[luke242]

I needed to show all appointments scheduled for the current week (Monday through Sunday). I used this criterea and was wondering if there was an easier way:

>=(Now()-Weekday((Now()),2)+1) And <=(Now()-Weekday(Now(),2)+7)

Just curious if I missed something obvious.

~Luke

 

[dhookom]

You could format your date field like:
TheWeek:Format([DateField]-1, "yyyyww")
and set the criteria to:
Format(Date(), "yyyyww")

I don't know if this would be more or less efficient.


Duane
MS Access MVP
Find out how to get great answers faq219-2884.