using day of week in a query

[klnlsu]

I have a logic question...I have processes set up in my database that I run on certain days of the week (some processes run more that once a week). I have a combo box that uses a process sequence table to show me what order to run my processes in. I would like to set up Boolean fields in my process sequence records for each day of the week that I can turn on or off depending on whether I want to run that process that day, then my combo box would only list the processes to run for that day. I know how to use the DatePart function to find the day of the week, but how do I compare that to my fields in my table? Keep in mind that some of my processes run more than once a week, so I can't simply create a single field with a weekday number or day in it. I may be making a mountain out of a molehill. Can someone help?

[ranman256]

in the query , format 1 field to give DOW: format([datefield],"w")
Sun=1, Mon=2....

if you need, make a table of tDOW,
1,Sun
2, Mon
etc

then you can join the text day from the form combo box,
this would filter on tDow joined to the query and the numeric field format([datefield],"w")
and only pull data for that one DoW.

[klnlsu]

That works! Thanks.