result.PNG

<div>
In report design:<br />
<br />
Add Group On Expression: Year(theDate)<br />
Add Group On Expression: Month(theDate)<br />
<br />
In Month group header:<br />
add a field: =Year(theDate) &amp;&nbsp;&quot; - &quot;&nbsp;&amp; Month(theDate)<br />
add a field: =Count(theDate)
</div>


In report design:

Add Group On Expression: Year(theDate)
Add Group On Expression: Month(theDate)

In Month group header:
add a field: =Year(theDate) & " - " & Month(theDate)
add a field: =Count(theDate)

<div>
<div class="content wysiwyg-content">
I need to pull a query that returns information about quotes issued on a system by month. Specifically I need to see how many quotes, per month a particular rep has issued. I don't want to see a list of all the quoted dates, rather a list of all the months of the year with a number, or a zero, next to each month showing how many quotes have been issued.<br />
<br />
Any suggestions welcomed.
</div>
</div>


I need to pull a query that returns information about quotes issued on a system by month. Specifically I need to see how many quotes, per month a particular rep has issued. I don't want to see a list of all the quoted dates, rather a list of all the months of the year with a number, or a zero, next to each month showing how many quotes have been issued.

Any suggestions welcomed.

Group Access data by month

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.