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 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 |
All times are GMT +1. The time now is 01:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com