ChuckCasey
MIS
I have a database that logs customer visits. I want to pull only records for customers who visited on Saturdays for the last month. Could someone please help me with the query criteria to make this happen? Many thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Query records for a particular day of week
- Thread starter ChuckCasey
- Start date
- Status
SkipVought
Programmer
Hi,
[tt]
...
Where VisitDate Between DateSerial(Year(Now), Month(Now)-1, 1) and DateSerial(Year(Now), Month(Now), 1)-1
And Mod(VisitDate,7)=0
[/tt]
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244
[tt]
...
Where VisitDate Between DateSerial(Year(Now), Month(Now)-1, 1) and DateSerial(Year(Now), Month(Now), 1)-1
And Mod(VisitDate,7)=0
[/tt]
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244
- Status
Similar threads
- Locked
- Question