title: Data type mismatch in criteria expression MS Access SQL query
body: <p>When i run the query the below, i get the error `Data type mismatch'</p>
  
  <pre><code>SELECT o.name as Name,
  Month(CDate(type.Value)) as ValueType
  FROM (t_obj as o
         INNER JOIN t_prop as type 
           ON o.Obj_ID = type.Obj_ID)
  WHERE type.Property LIKE 'Tech*' 
    AND Month(type.Value) = 5
  </code></pre>
  
  <p>However if i run the query as follows, it works just fine</p>
  
  <pre><code>SELECT o.name as Name,
  Month(CDate(type.Value)) as ValueType
  FROM (t_obj as o
         INNER JOIN t_prop as type 
           ON o.Obj_ID = type.Obj_ID)
  WHERE type.Property LIKE 'Tech*' 
  </code></pre>