Querying a day of the week

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

Access Painter

I have a table that has a Time/Date field and I want to query just the info
from Saturdays. The field is formatted in the long date format so it includes
the word "Saturday". How do I write the criteria?

I have tried "Like" and it dosn't work. I have used that before to query
street names that were in the same field with the rest of the billing address
with no problem.

I tried changing the Date/Time field to a text field and that dosn't work.

Any Ideas
 
In query design view, type this into the Field row:
Weekday([YourDateFieldNameHere])
Substitute your date/time field name.

In the Criteria row under this, enter:
7

(I'm assuming you changed your field back to Date/Time again.)
 
Back
Top