title: Search between date and time in access query
body: <p>I have the following data on a table<br>
  tbl Admission : Date and Time are two different fields and stored in <code>dd/mm/yyyy</code> format</p>
  
  <pre><code>AdmitDate          AdmitTime 
  1/6/2012            00:00
  3/6/2012            10:00
  3/6/2012            19:00
  4/6/2012            20:38
  5/6/2012            21:00
  7/6/2012            03:00
  </code></pre>
  
  <p>I would like to write a query to show all records between 3/6/2012 07:00:00 and 5/6/2012 06:59:59.</p>
  
  <p>The query should also have the option of having 'date' input from user (only the date &amp; time can be the fixed interval between 7 am first day to 6 59 am the second day) - for instance using PARAMETERS.
  I use access 2003.
  I tried several queries but am not able to perfect one - i do not get accurate results.
  Somebody please help.</p>
  
  <p>Thanks,</p>
  
  <p>Regards,</p>