Querying Date/Time over 24hrs 3

[hurricane]

Dear Forum,

I trying to create a query where I can filter any entries inputted between 05.59.59 yesterday and 06.00.00 today. This query must be able to work everyday without intervention.

I would really appreciate some help here before I loose my hair, marriage and job.

Thanks

H.

 

[DougP]

Well are you keeping track of the date too????

Also you might want to store the absolute value of a date and time in a special field and use it to compare rather than...

Look at "DateDiff" , "TimeSerial" and "DateSerial" functions in Help
Note: you can add and subtract with these too.

DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.

 

[hurricane]

Thanks... this is a great help.

H.