Run query based on condition-from a Newbie

[Coop]

I have a macro which exports data from Excel to Access. Some of the fields are weekday(Monday, Tuesday, etc.), business day (1,2,3,etc) ,calendar day (1,2,3,etc.), and various amounts in other fields. In Access, I have built 3 queries which use the weekday, business day or calendar day as criteria. Is it possible to change the criteria based on current day of the week without changing the criteria (day) manually? I was thinking that the Access equivalent of the Excel formula, text(today(),"dddd"), goes onto the Criteria field. Can this also be done with the current day query, using calendar day,using day(today()) as well? Thank you.

 

[Norie]

For the Access equivalent of TEXT try format:

Format(Date(), "dddd")

The function Day will return the calendar day:

Day(Date())

And finally Weekday will return the day of the week:

Weekday(Date())

Note: Date() replaces TODAY.

 

[Coop]

Thats what I needed. Thanks for the quick response.