query access database based on day of week

Report · Aug 10, 2006

I have a table that has a field named day, it is populated with the names of
days, monday, tuesday, wednesday etc. How can I query the database based on
the current day of the week. So if today is monday, I want all monday
records. Thanks

Report · Aug 11, 2006

Maybe something like

select * from t where dayfield =format(date(),'dddd')

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004