Pulling out Weekend days in Access 2003

[Jamie]

This is crazy, but I can't get this to work! I am re-using a database to create new reporting. It was a technician utilization database that I am reworking to show weekend days worked. I changed the date format to Long Date to show the day, then started a query. The query is looking for *Saturday* but pulls nothing in the date field that I just changed to Long Date. What am I missing?

Thanks!

 

[jdraw]

Perhaps you should show us some of the code you have.

 

[gemma-the-husky]

I would not test the speicfic text of a formatted date.

simply this.

if weekday(somedate) = vbsaturday or weekday(somedate) = vbsunday etc