days of week

[chris]

i have a database of days that cleaners clean certain
places. I wanted to do a query to find only days to clean
after tuesday. so this would mean not monday but it doesnt
work. does someone know how to do this?

 

[May]

try the follow code,
1-Sunday
2-Monday
3-Tuesday
you may try to play with the number with weekday to see
that it really means

SELECT Table1.name, Table1.date, Weekday([date],2) AS date1
FROM Table1
WHERE (((Weekday([date],2))<>2));

May
MCP in Access and SQL Server