Query for Day of week

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
 
R

Rob Parker

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Querying a day of the week 1
day of week 2
Week starts on Friday 2
Can't query datetime field formatted as m/d/yyyy 1
Date Function in query 3
Urgent - Calendar - Need 7 days for week selected 11
Query for previous week, Sun thru Sat, from date field 1
Parameter month query 4

Top