how to apply where condition on date field in msaccess

[GANsJob]

im using ado in vc++ for access db i have used this query but it shows "data type mismatch in critria expressing" SELECT * from FDetails where ddate = '05/29/2006' ddate is datetime field any one has solution for this problem regards Gan

[Michael Potter]

I believe MSAccess uses pound signs to deliniate dates.

SELECT * from FDetails where ddate = #05/29/2006#

[GANsJob]

thank u itz now working