Query Using Time

  • Thread starter Thread starter Chris
  • Start date Start date
C

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.
 
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
 
Back
Top