Total number of a certain response

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Create a totals query that groups by BoardPolicy and counts the violations.
Use this as the record source for your report.
 
How do you create a "total query"?

Duane Hookom said:
Create a totals query that groups by BoardPolicy and counts the violations.
Use this as the record source for your report.
Click to expand...
 
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.
 
Back
Top