Empty recordset query by time

  • Thread starter Thread starter larry cowan
  • Start date Start date
L

larry cowan

I have a table where one field is date/time format. Only the time value has
been entered. When I enter query criteria such as 9:01 PM Access 2000
converts the criteria to #12/30/1899 21:1:0# and return no records.
 
i have a table that has a date/time field that is set to Medium Date format,

if i enter 9am into the criteria of a query based on the table it returns
the records
here is the SQL that Access generates:

SELECT tblTimeValues.WarrantyExpire, tblTimeValues.Cust
FROM tblTimeValues
WHERE (((tblTimeValues.WarrantyExpire)=#12/30/1899 9:0:0#));

I am using Access 2002

Are you sure there is a record with exactly 9.01 (no seconds) in your
database?

HTH
 
Back
Top