title: How to get correct week number in Access
body: <p>I get a large data set every week, with Start Date and End Date, Start Date is always Monday and End Date is always Sunday. I want to be able to do a rolling YTD on Sales for different products by week. I am trying to give each week's data a week number. But my first week is 12/28/2015-1/3/2016, it keeps giving me week 53 instead of week 1. I saw another person's post on the same issue and dbDesigner's answer actually works:</p>
  
  <p><a href="https://stackoverflow.com/questions/1649720/get-the-week-number-from-a-given-date">Get the week number from a given date</a></p>
  
  <p>But this gives me 2016-01 in one column. I want two columns with one for correct week number and one for correct year to be able to do a sub query for my rolling YTD sales. For example for my first week 12/28/2015-1/3/2016, it will be week: 1 and year:2016</p>
  
  <p>Thanks.</p>