G Gano

I have a report that lists the total number of mediation cases we have processed, along with other related relevant data. The report is sorted so that the individual mediators are listed in order by their last name. This way we are able to easily keep track of the number of mediations processed by each of our three mediators, which is the purpose of the report.

For example: When the report is opened, in alphabetical sort order from top to bottom, J. Doe's name appears 24 times, indicating he has mediated 24 cases; then J. Evan's name is listed 61 times, indicating he has mediated 61 cases; and finally J. Wagner's name is listed on the report 15 times, indicating he has mediated 15 cases.

The problem: Reading the report one has to manually count the number of cases under each name to determine the number of cases each has mediated. Instead of doing a manual finger count, is there a way to create a query, and an ensuing report, that will just show the physical number of cases mediated by each person. For example: J. Doe: 24; J. Evans: 61; J. Wagner:15? I am sure there is a calculation that will give me the result I am looking for, but I need assistance creating it.

Basically the calculation would count the number of times each person's name (field name=Facilitator Assigned) appears in the underlaying table, and then give the result. How would I structure such a query?

Many thanks for anyone's assistance.

Gary G.
Houston, TX

wolfehall

Have you considered grouping by Facilitator Assigned and then adding an =Count([Cases]) field to the header or footer? [Cases] would be whatever you named your field in the original table.

wolfehall

If you don't need the specific case detail, you can select "Hide Details" and your report would be just the summary of # of cases for each Facilitator.

~ H.