Adding a groupfooter to an access report?

[Guest]

Hello, I'm extremely new to Access Databases, but I've built a report that
tracks errors made by individual operators. I have a total of about 200
operators on the tables, and a wide variety of error descriptions associated
to each. While the report I have generated is visually appealing, I find
myself having to analyze with Excel and then applying the formulas to get a
total count of errors. What I'm wondering is if I have a GroupFooter to go
along with the header of the Person Responsible will I not be able to then
Sum the Error Descriptions? Problem is I don't know how to add a group
footer to the report. I know I ramble on, and for that my apologies. Can
anyone offer any insight?

 

[Marshall Barton]

Hello, I'm extremely new to Access Databases, but I've built a report that
tracks errors made by individual operators. I have a total of about 200
operators on the tables, and a wide variety of error descriptions associated
to each. While the report I have generated is visually appealing, I find
myself having to analyze with Excel and then applying the formulas to get a
total count of errors. What I'm wondering is if I have a GroupFooter to go
along with the header of the Person Responsible will I not be able to then
Sum the Error Descriptions? Problem is I don't know how to add a group
footer to the report. I know I ramble on, and for that my apologies. Can
anyone offer any insight?

Open the report in design view, then use View menu item
Sorting and Grouping to see the report's groups. Click on
your grouping field in the top part of the window, then
select Yes in the Group Footer property in the lower part of
the window and away you go.