How can I pull Access information by day of week?

[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)

 

[Tom Lake]

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)

Add a calculated field to your query:

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

Then in the Criteria for that field, use

="Monday"

Tom Lake

 

[peregenem]

How can I retreive information based on day of week? (i.e. all
Mondays)

Add a calculated field to your query:

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

Then in the Criteria for that field, use

="Monday"

A integer comparison may be preferred

WHERE WEEKDAY([Date] ,2) = 1