Thanks Steve...
However I'm trying to apply the query criteria to the date field itself...
If my criteria is..
<Now()-2
This returns all records over 2 days old
If my criteria is..
<Now()-3
This returns all records over 3 days old
However... what I'm tring to do is combine both criteria in...
I have an access database that among other data stores within each record the date a transaction on that record occured.
I am trying construct a single query to return records that are over 2 working days old unless the query is run on a monday then the query must return records that are over 3...
I have a small network with a PDC and one BDC. I have directory replication tested and working ok. I have checked the policies and associated files and permissions on both DC's and all seems identical on both. However when users log onto the network and are authenticated by the BDC they get the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.