Total number of a certain response

[Guest]

I have a form users fill out to record suspension information for students.
When they fill out these suspension reports, they have to specify what Board
Policy was violated. This field is called BoardPolicy
I want to be able to create a report so that I can total the number of all
board policy violations. For instance, if policy 5402 was violated 25 times
and then policy 5445 was violated 35 times, I want to be able to create a
single report that shows the number of violations for all reports.
How would I accomplish this?

 

[Duane Hookom]

Create a totals query that groups by BoardPolicy and counts the violations.
Use this as the record source for your report.

 

[Guest]

Thank you so much for your response.
I am looking up how to create the total query now

 

[Guest]

How do you create a "total query"?

Create a totals query that groups by BoardPolicy and counts the violations.
Use this as the record source for your report.

 

[Duane Hookom]

Did you try Help? Press F1 to get into Help and select the Index tab. Enter
the word "Total" and press enter. The "Total records in a query" Topic
should help.