AnsweredAssumed Answered

Creating a Report to Count Number of Instances of a Field

Question asked by EV on Feb 15, 2013
Latest reply on Feb 18, 2013 by philmodjunk

Title

Creating a Report to Count Number of Instances of a Field

Post

     I am creating a database to manage data about students from various schools within a district.  I would like to create a report that would count the number of records for a particular school.  For example, if the schools in the district where Lincoln, Washington, Kennedy, Roosevelt, Polk, and Harrison, I want to create a report that would list the number of students whose records match each school.

     So, it would return data such as:

     Lincoln  34

     Washington  29

     Kennedy  56

     Roosevelt  70

     Polk  4

     Harrison  11

     After determining how to do this, I would like to replicate it for (or break up the school data into subcategories based on) gender, ethnicity, etc.

     I have tried looking for a solution (and I could have easily missed something), but I have failed to find anything.

Outcomes