select where = time

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

Try this approach...

Code:

---


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

---

you have to use ' instead of " in a SQL statement when
you need to establish a comparison


saludos...;)