Date/Time Query (HELP!) 1

[Fresh]

I'm a newbie so bare with me...

I'm querying multiple tables in a an Access DB. I'd like the query to include only results for items time stamped from yesterday after 4:00pm to the present.

I've used

>=Date() Or >=Date()-1

This gets me yesterday and today but can't figure how to narrow down the time. The time format in the table is

10/19/01 10:32:03 AM

Thanks for any help!

 

[lameid]

To use a literal date/time in code you need to put # symbols around it. The "#" is the date delimeter much like double quote (&quot is a text delimeter.

>= #10/18/01 4:00 PM#

Or >= Date + #4:00 PM# - 1

 

[CosmoKramer]

Try:

>Date()-1 & " " & #4:00:00 PM#