title: how to search between 2 dates and times in access?
body: <p>i have in my access fields <code>MyDate</code> and <code>myTime</code>.</p>
  
  <p>MyDate in format: <code>16/09/2010 00:00:00</code></p>
  
  <p>MyTime in format: <code>16/09/2010 04:27:00</code></p>
  
  <p>i need to search between <code>date 01/01/2010 and time 12:50:00  - and - date 12/11/2010 time 01:34:00</code></p>
  
  <p>which  query i need to write  ?</p>
  
  <p>thank's in advance</p>