How can I pull Access information by day of week?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Microsoft Access file with a lot of different fields, one being
date. How can I retreive information based on day of week? (i.e. all Mondays)
 
Ed said:
I have a Microsoft Access file with a lot of different fields, one being
date. How can I retreive information based on day of week? (i.e. all
Mondays)
Click to expand...

Add a calculated field to your query:

DOW: Format([date],"dddd")

Then in the Criteria for that field, use

="Monday"

Tom Lake
 
Tom said:
How can I retreive information based on day of week? (i.e. all
Mondays)
Click to expand...

Add a calculated field to your query:

DOW: Format([date],"dddd")

Then in the Criteria for that field, use

="Monday"
Click to expand...

A integer comparison may be preferred

WHERE WEEKDAY([Date] ,2) = 1
 
Back
Top