Query for Day of week

  • Thread starter Thread starter Access Painter
  • Start date Start date
A

Access Painter

I posted this earlier but it never showed up. Sorry if this is a duplicate!

I want to return info from a table using a query that only returns the info
that occured on Saturdays. The date field is formatted as a Date/Time field
formatted for the long date. Example: Saturday November 20 2008"

How do I write the criteria? I have tried "Like" as well as "and". Short of
entering 52 dates in the criteria I am stumped.

Any Help Appreciated
 
Add a calculated field to your query, with the expression:
Weekday([YourDateField])
Set the criterion on this to 7, and you will return only Saturdays.

Rob
 
Back
Top