### Title

Totally the number of schools in a report

### Post

I am writing a report that gives me the number of students with special needs in a school district. I can find the total of students in each school district but I want to find the total number of schools. When I count the number of schools I get the same total as the number of students.

Even though there are 5 students from one school can I get the value of the school changed to 1 instead of 5.

So if I have 300 students in total I may have a total of 32 schools instead of 300.

The tables or databases you use?

The relationships?

All info is good.