select where = time

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

What about trying this:

Code:

---

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

---

Replace the ' with a # ...

Hope this helps.

Michael

Thanks Michael, That did the trick

Joe