Count in Report

[bigbadbess24]

I am trying to count how many times a name comes up. I dont want to tally how many in field.
For example. I have a field name: School District. Underneath that I have hundreds of schools. I want to know how many times JFK High School or Plainview High School in a report.

Thank you

 

[WayneRyan]

Bess,

You can use the Sorting/Grouping feature of the report. Group on
the SchoolDistrict field, in the footer for the group set a field
to 1 and choose Running Sum. That will give you the count of how
many entries for each one.

Wayne

 

[bigbadbess24]

I could not find the option for Running Sum un the sorting/group feature

 

[Pat Hartman]

The RunningSum property is not on the sorting/grouping dialog. It is on the Data Tab of the properties for the field you added to the SchoolDistrict footer.