title: Ms Access to show only previous week's records
body: <p>In MS Access I am trying to filter to show only records from previous week.
  I have colums showing weeknumber based by record date. 
  Using  <code>DatePart("ww",Date(),2,2)-1</code> in criteria field works well if current week is not 1. It does not work to previous year.</p>
  
  <p>How I can show only records from previous week or 2 weeks, even if it goes to previous year?</p>