title: Access Pivot Query returns dates not included in where clause
body: <p>Straight forward pivot query below running in access 2010. I'm hoping to extract login/logout records between dates in August - However September records are included in the result - I cannot fathom why.</p>
  
  <pre><code>TRANSFORM Min([TimeIn]+" - "+[iSparky]![TimeOut]) AS InOut
  SELECT iSparky.NAME, Count(iSparky.TimeIn) AS [Total Of TimeIn]
  FROM iSparky
  WHERE ((([iSparky]![DateIn])&gt;#8/15/2013# And ([iSparky]![DateIn])&lt;#8/20/2013#))
  GROUP BY iSparky.NAME
  ORDER BY [iSparky]![DateIn]
  PIVOT [iSparky]![DateIn];
  </code></pre>
  
  <p>Any Suggestions would be most appreciated - thanx for your time and efforts as always :)</p>