I want to select from an Access database where = to a time value. I get a data type mismatch in criteria error.
Anyone have any any ideas?


SELECT [FaxLog].[FaxIdNbr]
FROM FaxLog
WHERE faxarrivaltime="3:36:33 PM";

Thanks