title: Access query (SQL) to return records sorted (grouped by) WEEKS
body: <p>Greetings SQL gurus,</p>
  
  <p>I don't know if you can help me, but I will try. I have several large databases grouped by year (each year in a different database). I want to be able to compare values from a particular week from one year to the next. For example, "show me week 17 of 2008 vs. week 17 of 2002." </p>
  
  <p>I have the following definition of weeks that ideally I would use:</p>
  
  <ol>
  <li>Only 52 weeks each year and 7 days a week (that only takes 364 days),</li>
  <li>The first day of the first week starts from January 2nd - which means we do not use January 1st data, and</li>
  <li>In leap year, the first day of the first week ALSO starts from the January 2nd plus we skip Feb. 29.</li>
  </ol>
  
  <p>Any ideas?</p>
  
  <p>Thanks in advance.</p>