title: MS Access SQL to Select date range
body: <p>I need to select a record with dates which has dates ( in range: form 1998 to 1999). I wrote the statement which did seem to work . Why?</p>
  
  <pre><code>SELECT *
  FROM Factory
  WHERE 
  (EXTRACT(YEAR FROM date) AS dyear) BETWEEN '1998'  AND '1999'
  </code></pre>