title: query criteria to show records for a certain month
body: <p>I have some records in a query with a column of dates. I want it to only show the records that occur in March. This link 
  <a href="https://support.office.com/en-US/Article/Examples-of-query-criteria-3197228c-8684-4552-ac03-aba746fb29d8#bm1" rel="nofollow">https://support.office.com/en-US/Article/Examples-of-query-criteria-3197228c-8684-4552-ac03-aba746fb29d8#bm1</a> shows the different types of criterion.</p>
  
  <p>The one below in the table describes how to show only what occurs in a particular month:</p>
  
  <p>"Contain a date that falls in a specific month (irrespective of year), such as December</p>
  
  <pre><code>DatePart("m", [SalesDate]) = 12
  </code></pre>
  
  <p>Returns records where the transactions took place in December of any year."</p>
  
  <p>I don't know what the SalesDate means in the criteria function, and there isn't any explanation on the page.</p>