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
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,