Display only Weekdays in Access Query

A

Amit

I have data that is collected everyday in a table and I am
trying to write a query that shows the data collected only
on the weekdays (excluding Saturdays and Sundays)

I tried Weekday(date,2) which gives me numbers from 1 to 7
for Monday to Sunday. Then I try putting the criteria in
this field (< 6) so that I only get 1 to 5 for Monday
through Friday. I get a "Type Mismatch Error"

Thanks in advance for your help!
 
Top