Query Using Time

[Chris]

My table name is Master. I would like to create a query that uses the field
[Login] from the Master table. I would like for the query to display any
entry that comes after 8:05:59 AM. I have tried using >#8:05:59 AM#, but
this does not work. Please offer any suggestions.

Thanks.

 

[Chris]

Nevermind...fixed the issue.

Thanks.

 

[Arvin Meyer [MVP]]

It probably doesn't work because a Date/Time field does just that, puts in
the date and time, even if you only display the time. Change your table
format of the field temporarily to determine if only the time is accurate:
mm/dd/yyyy hh:nn:ss AM/PM Your time may look like this:

12/30/1899 11:10:47 AM

or if you are using Now(), it will look like:

12/29/2009 11:10:47 AM