Data type mismatch in criteira expression

Posted by Davit Siradeghyan on Stack Overflow See other posts from Stack Overflow or by Davit Siradeghyan
Published on 2010-05-10T10:49:07Z Indexed on 2010/05/10 10:54 UTC
Read the original article Hit count: 385

Filed under:
|
|
|

I'm getting this error: Data type mismatch in criteira expression when trying to execute this query in access:

select sum(total_sum) from totals_table where tot_date >= '3/01/2010' and tot_date < '4/01/2010'

P.S. tot_date is of type Date/Time and tot_sum is of type Number

© Stack Overflow or respective owner

Related posts about sql

Related posts about ms-access