title: Access query to pull previous month's data
body: <p>I have a table in Access 2013 (Table1) that contains the following columns:</p>
  
  <p>ID (pk), ReportDate, Amount</p>
  
  <p>The most current data is 30-50 days old. For example, today (6/22/16) the most recent data would be the 5/1/16 row, as the 6/1/16 data won't be entered until mid-July. (All dates in the ReportDate column are the 1st of the month, i.e.: 4/1/16, 5/1/16, etc.)</p>
  
  <p>I need to write a query that will do a 6-month lookback, but exclude the most current month's data.</p>
  
  <p>So, for example, if I ran the query today (6/22/16), I would only get the rows that correspond to the following months:</p>
  
  <pre><code>12/1/2015
   1/1/2016
   2/1/2016
   3/1/2016
   4/1/2016
  </code></pre>
  
  <p>The data for 5/1/16 should be excluded, as it's the most recent month.</p>
  
  <p>I can pull the previous 6 months worth of data with setting the criteria (in QBE) for ReportDate to<code>&gt;=DateAdd("m",-6,Date())</code>, but I can't seem to figure out how to exclude the most recent month. </p>