Needing to group Businesses and give totals in report

[Maven4Champ]

I have an Access Report question.

In my database I have groups (i.e. Collections, Accounts, Sales, etc.)

I do reporting for these groups and want to create a report that sums the Report Count field associated with each individual request.

Right now it looks like this

Request ID #1 - [Count]: 3 [Group]: Collections [Subject]: This is a report request.
Request ID #2 - [Count]: 2 [Group]: Collections [Subject]: This is another request.

What I want to show in the report is this:
[Group]: Collections [Total Count]: 5
[Group]: Sales [Total Count]: 3

or something similar in that nature. I can't seem to achieve this grouping and sum within the report itself. Can anyone provide assistance on how I could acheive this, whether it be in a query or a report?

Thanks

 

[Andrew Fergus]

I'm not sure I follow you 100% but in your report design, click View -> Sorting and Grouping, make sure the [Group] (or [Groups] depending on the actual name) field is added, on the same screen in the group properties make sure the group header and footer are set to yes (for the [Group] or [Groups] field). You should see some new sections appear on your report. In the Group footer section of the report, add an unbound text box and make the control source something like =Count([Request ID]) or whatever field you wish to count. I would advise against using a variable name such as 'Count' because it will be confusing and may cause problems, I usually use something like TotCount.
HTH, Andrew.

MS help resources available here and here