title: Access 2010 Query for current month
body: <p>I have built an Access database to keep track of Quality Assurance Monitors for our team.  Our team has several leads that oversee the reps on the team.  </p>
  
  <p>I want to build a query the will return all of the QA's for a specified lead for the current month.  I have criteria for specifying a lead and have got that to work, but every time I try to set the criteria for the current month, it ends up returning no results.  </p>
  
  <p>Searching Google has repeatedly suggested using the <code>Month(Now())</code>, but that doesn't work either.  </p>
  
  <p>How can I write this query?</p>