Remove Saturdays from list of dates

[Adam]

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]

Adam,

WHERE WeekDay(Date(), 7) <> 1

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