title: Data type mismatch in criteria expression
body: <p>I'm getting this error: Data type mismatch in criteria expression when trying to execute this query in access:</p>
  
  <p>select sum(total_sum) from totals_table where tot_date >= '3/01/2010' and tot_date &lt; '4/01/2010'</p>
  
  <p>P.S. tot_date is of type Date/Time and tot_sum is of type Number</p>