Hi there!


I'm getting an exception while fetching a row from Access with where clause in [date] column.


My statement is:

   SELECT s_date FROM table1 WHERE s_date='10-12-2006';


Exception Generating:

    Data type mismatch in criteria expression.



Thanks.

Deepak..

__________________
DPK..

hi there...

if s_date is a date field the data should be between #10-12-2006#;

HTH

Gonzalo

Thanks Gonjalo!
Now I got it.
:)

Deepak..