Changing Criteria Based on the Weekday (1 Viewer)

I have inherited a module that looks at the weekday (date). If it's Monday, it runs one query, if it's Tuesday, it runs another.

Can I put the criteria itself directly in the query or should I just keep it 'simple'?

I say 'simple' because after it runs, it's exported to Excel, and it takes the name of the query, which can sometimes cause some confusion as people see the Excel workbook with one name one day and another name another day.

open the reporting form, with a combo box
the combo has dow, mon,tue,wed.
it gets set upon open , form_load() event
set combo to the day,
cboDoW = format(date(),"www")
the query opens this

you must make a query for every DOW
qsMon
qsTue
qsWed

My gut tells me these different queries could be combined into one query, using the Day of the week as criteria. Are all of these queries based on the same datasources?

JoeGKushner said:

If it's Monday, it runs one query, if it's Tuesday, it runs another.

Click to expand...

This doesn't make sense in principle. Time is a scalar quantity just like dollars or inches, so you should use that quantity itself. For example, you would never run one query for 6 inches, and a different query for 7 inches, and a different query for 8 inches. Rather, you would pass the measure to the query regardless of its value. Similarly, with time, pass the time itself to the query, no need to pre-process how much time.