select where = time

[courchjo]

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

[D12Bit]

Try this approach...

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