SPECIFY DATE/TIME IN CRITERIA FOR QRY WITH "GENERAL DATE" 1

[floydpepper]

Ladies and Gents,
I have a dbase that records events based on date/time occurred, event type, etc. Right now I have a qry with criteria set to Between (Now()-1) and (Now()). How can I set the criteria to go from yesterday at 0430 (am) to Now() (time of qry)? Or set the criteria to 0430 to 0430 as a daily report? Thanks in advance for your patience and assistance.

Floyd P

 

[PHV]

Take a look at the DateSerial and TimeSerial functions. You may add their return values to obtain a DateTime value.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[OnTheFly]

Try

Between DateValue(Date()-1 & " 6:00:00 AM") And Now()



Hope this helps.

OnTheFly

 

[OnTheFly]

Sorry, I forgot to modify the time

Try this:

Between DateValue(Date()-1 & " 4:30:00 AM") And Now()




Hope this helps.

OnTheFly