title: Access query won't work when dates have times
body: <p>I have a query stated:</p>
  
  <pre><code>select *
  from tblClient
  where IntakeDate = #5/31/2011#
  </code></pre>
  
  <p>I know for a fact there are 8 records that have that date. But none of records with that date are pulled by this query. Those 8 records have times as well as "short date" (e.g. "5/31/2011 1:42:00 PM")</p>
  
  <p>As a test I set the date to exactly 5/31/2011 for one record, and the query will work for that one record. Clearly the time value is interfering with this query.</p>
  
  <p>I do not want to change all the date data to a strict 'short date' format and would like to work with it as-is. Can anyone give me some idea how I can make this work?</p>