Anilrgowda

I have a MS Access database table with a DateTime field in it. The following INSERT statement works:

INSERT INTO Table VALUES(...., '4/26/2007 5:25:59 PM', ....)

but the SELECT statement never works when I specified the same string (it gives me Data Type Mismatch error):

SELECT * FROM Table WHERE .... AND Time = '4/26/2007 5:25:59 PM' ...

What is the correct way to do this? Thanks!

------------------

Anilrgowda

Bharat is right. "Time" is a reserved word AND a function in access and shouldn't be used by itself as a field name, if possible, change it to TheTime or MyTime. Otherwise you need to surround it with brackets as shown.

The reason your insert statement works is because you're inserting the date as a text string, but happens to fit the General Date/Time format.

The select doesn't work the same way, it's value based and therefor the criteria has to match the data type for the field. Surrounding the date/time with # # tells Access Jet that it's a date.

SELECT * FROM Table WHERE .... AND [Time] = #4/26/2007 5:25:59 PM# ...

------------------