query problem

**todd2006** · todd2006, May 5th, 2010 04:49 PM

Hello,

I have this query

Code:

str="select std.*, stdpay.* from std inner join stdpay on std.id=stdpay.id where stdpay.paymentdate between '1/1/2010' and '3/1/2010'

its gives an error data type mismatch in crietria expression

paymentdate is a datetime filed in access

thanks

todd

**richyrich** · richyrich, May 5th, 2010 04:59 PM

If using Access, I think dates need a # before and after. Something like:-

Code:

str="select std.*, stdpay.* from std inner join stdpay on std.id=stdpay.id where stdpay.paymentdate between #1/1/2010# and #3/1/2010#"

Thread: query problem