Query that gets record on a certain day of week like Monday

[reve]

Need to build a query that will only pull up records on monday. Have advertisers who run specials on cetain days of the week and need to make a query that will only get records on that day of week. like date() for today but can't find anything on days of week.

[NTC]

Day of Week is available in VBA. In your query add a calculated field with an approach shown below - and then use your criteria here to filter.

DayName: Format([TheDateField],"ddd") for abbreviated nameorDayName: Format([SomeDateField],"dddd") for full name