weekday function in WHERE

A

Alex

I need to get working days without Sundays from a table for the period from
Feb1/04 till May26/05. I'm trying to use the Weekday function.

Using the following query I can get all Sundays.

SELECT tblProduction.Day, tblProduction.[Scheduled Hrs] FROM tblProduction
WHERE (((Weekday([Day]))=1));

But, when I'm trying to get days without Sundays using Weekday([Day])>1 or <>1
I cannot get full February but only from Feb 25th. The rest of months looks
fine.

Could anybody clarify how could I fix it?

Thanks
 
A

Alex

I found it. It wasn't sorted by dates and I couldn't see those rows for
February.

Thanks
 
Top