select where = time

[courchjo]

Yea, I had that to begin with.

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

This gets the same message. DataType mismatch

Thanks,

Joe

[Michael Woolsey]

What about trying this:

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

Replace the ' with a # ...

Hope this helps.

Michael

[courchjo]

Thanks Michael, That did the trick

Joe