Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to identify when similar records appear in two sets of data | Excel Discussion (Misc queries) | |||
compare two spreadsheets and identify records that have any change | Excel Discussion (Misc queries) | |||
Can You Query Specific Access Records from Excel? | Excel Programming | |||
How to Get records from a query in access and put them in Excel | Excel Programming | |||
How to Get records from a query in access and put them in Excel | Excel Programming |