Summing in Groups

[Ed S.]

I have a report that is divided into multiple sections:

Division
Class
Section

Each section includes a count of the number of males & females in the class
[txtMaleCount] & [txtFemaleCount]. I have tried a sum in the Class &
Division section "=sum([txtMaleCount])" and "=sum([txtFemaleCount])".
However, each time I try to view the report, it asks for paramenters for
"txtMaleCount" and "txtFemaleCount".

Any suggestions?

Thanks!

 

[Allen Browne]

You can sum fields that are in the report's source query, not text boxes.

I'm guessing that txtMailCount is a text box on the report.
Perhaps it has a ControlSource such as:
=Sum(IIf([Gender]="M", 1, 0))

If so, repeat the *same* expression in the report footer to get the total
over the whole report.

(As an aside, this might not give the correct number of individuals if you
have some people who work part time in multiple sections.)