title: Displaying totals within a specified date range in Microsoft Access
body: <p>Although I have experience with SQL and generating HTML reports with PHP, I'm a relative beginner with Microsoft Access.</p>
  
  <p>I'm currently using Microsoft Access 2007 to connect to MSSQL Server 2005.</p>
  
  <p>I have a table of Reports that looks something like this:</p>
  
  <pre><code>ReportID
  DateCreated
  Author
  ...
  </code></pre>
  
  <p>I'd like to create a form that allows the user to specify a start date and an end date, which would then show the number of reports by each author within the specified date range.</p>
  
  <p>I've already done this in a form by first retrieving a list of unique authors into a combo box, and then allowing the user to select the author, start date, and end date, and displaying the count in a text box.  However, I was wondering if there was an easier or better way, or if there was a way to display all of the authors and their totals simultaneously.</p>
  
  <p>Thanks in advance :)</p>