title: Microsoft Access SQL to query a date range ignoring the year
body: <p>I need to select records based on a range of month/day values, disregarding the year. I am querying an Access database, and I found a query <a href="https://stackoverflow.com/questions/15790213/ms-access-sql-to-select-date-range">here</a> but it seems to select a range of years.</p>
  
  <pre><code>SELECT *
  FROM   Factory
  WHERE  YEAR(date) BETWEEN 1998 AND 1999 
  </code></pre>
  
  <p>I have tried this query, but it only shows birthdays in the current year :</p>
  
  <pre><code>SELECT * FROM user where birthday Between #09/05# and #10/10#;
  </code></pre>
  
  <p>In my database the birthday column contains the year to count how old they are. What query can I use to perform what I want?</p>