Is there a way to query a date field for a certain day? "Monday"

D

Dknudson

I am tying to filter a time card database for all time entered on a monday.
Is there a way to do this besides entering each monday's date separately?
 
V

Van T. Dinh

You can use the Weekday() function to return the day of the week and check
that it is Monday.

Check Access VB Help on the Weekday() function.
 
Top