title: How do I write the Criteria in Query Design to equal last month's data?
body: <p>I've looked on a couple different forums and I'm unable to find what I need they all have it listed in SQL View, and that is NOT what I want. I would like to do this in the Query Design as it is much easier for me. </p>
  
  <p>I simply would like to make a query to display certain parameters of the database I maintain. And those parameters would equal last month's data. </p>
  
  <p>I previously was able to successfully make a query displaying all information for the past year but can't figure out how to display just this past months.</p>
  
  <p>The past year Criteria:</p>
  
  <pre><code>&gt;DateAdd("yyyy",-1,Date())
  </code></pre>
  
  <p>Since that worked I tried doing this but it would not work for me:</p>
  
  <pre><code>&gt;DateAdd("mmmm",-1,Date())
  </code></pre>
  
  <p>I'm sure it's something simple that I'm just not seeing here. Any help or recommendations are welcome.</p>
  
  <p>Referencing the link provided by Fionnuala I have come up with</p>
  
  <pre><code>&gt;DateAdd("m',-30,Date())
  </code></pre>
  
  <p>The problem being is that it queries all results for the past 30 days from Today's date. I wish to display only data from October ! While this can be done easily. I don't wish to manually go in this query every month and change certain parameters. I would like it to be automatic so or next month December I click on the query and it displays all 30 days of November's data. And there is no manual process of going back in and changing any of the criteria. </p>