MS Access Query Identify Friday's records.
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
Wednesday's query would have Tuesday's records
Thursday's query would have Wednesday's
Friday's query would have Thursday's
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?
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1