| | |
|
|
|
Remove Saturdays from list of dates |
| message from Adam on 25 May 2004 |
Hi,
I use a query to give me a list of records that includes
dates (long date format), such as Friday, 31 October 2003.
I want to exclude Saturdays from the retrieved records, so
that only records that have a date that falls on a weekday
will show.
I tried to set the criteria <>Saturday and Not = Saturday
and other ideas but I haven't cracked it so far.
May I please ask how this is done?
Thanks in advanced.
Adam
|
| Graham R Seach replied to Adam on 26 May 2004 |
Adam,
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html
"Adam" <anonymous@discussions.microsoft.com> wrote in message
news:1283201c442cf$93476650$a501280a@phx.gbl...
|
|
Archived message: Remove Saturdays from list of dates (MS Access)