Display a list of the count of each unique value in an Access report.

[TonyD1016]

Good afternoon.

I'm currently trying figure out how to display some information in a quarterly report in Access.

I have a table that lists the invoices received by date and a field that lists the county that the vendor is located in.
I have a query that pulls the necessary information in this table into a report which I filter by quarter using the DatePart function on the DateReceived field.

What I would like to have as part of that report is a list of the number of times each county has appeared within the specified dates.

My first effort was to create a subreport that grouped the original query by County and put a [County] textbox in the Group Header nextt to a second one with "=Count(*)". But when I put this subreport in the header of the main report, it would only display whichever county was the first record in the main report and none of the others.

What is the best way to accomplish what I am trying to do?

 

[Micron]

I usually stumble through these solutions if I have something to work with. In absence of that, you need to examine the sorting and grouping options in report design. In that view, from design tab, turn on Sorting and Grouping (ribbon). If you are grouping by county you can select Totals options for a group (field and then operation, such as count, sum). If you're not, sometimes the answer is to hide a textbox, set its value to 1 and set it to be a running sum. You might have to research some of these terms. Note that report design ignores query sorting, so don't expect report output to mimic query design.