title: Data Mismatch Error Access query
body: <p>I am trying to get the target data for a specific period using <code>left join</code> and <code>between</code> function as in code below. However I get Data mismatch error when I run the code and when I remove the <code>betwwen</code> code the query runs properly.</p>
  
  <p>Tried playing around with the brackets, no luck till now. </p>
  
  <pre><code>FROM Qry_Status 
  LEFT JOIN Qry_Target ON (Qry_Status.[Dept Code] = Qry_Target.[Dept Code]) 
  And (iif(IsDate(Qry_Status.sDate),Qry_Status.sDate Between ([Qry_Target].[From_Date]) 
  And ([Qry_Target].[To_Date])))
  </code></pre>