In MS Access, I have a Query which looks at the last business day
records entered into a database.

Using the criteria in the Query by example desgin: <Now()-1

This works fine for business days records in Tuesday, Wednesday and
Thursday and Friday.

Beacause using the critieria: Tuesday's query would have Monday's
records entries.
Wednesday's query would have Tuesday's records
entries.
Thursday's query would have Wednesday's
records entries.
Friday's query would have Thursday's
records entries.

The problem occurs when I want to look business day records for Monday.
Whereby, Mondays records
should have last weeks Friday entries...


Is there a solution to overcome this problem?

Kind regards,

Brenda