title: MS Access select between two dates?
body: <p>I have searched, but all results didn't help me to understand.</p>
  
  <p>I need to select names of people who are 18-23 years old.
  So my try was: </p>
  
  <pre><code>WHERE ((People.Birth) Between (Now()-Year(18)) And (Now()-Year(23)))
  </code></pre>
  
  <p>What I'm doing wrong? Solution as #some_date# is a bad idea!</p>