Calculate # of Males/Females in group headers

[rm76]

I have an Access ADP with a report that has two grouping levels, Treatment Modalities [Modality] and then Counselor Name [StaffID], (grouping is done on the report, not the query). What I'd like to do is calculate the number of males and females in each group header on the report. There is a Gender column in the query to calculate it. I've tried calculating in the query but cant get it to calculate the groupings right. I've tried using an expression in a textbox on the report using sum(iif) but always get invalid column errors. Any suggestions? Thanks!

 

[danvlas]

What is the data type of Gender column?
If Yes/No, you could try Sum(Gender) and Count(Gender)-Sum(Gender).


HTH


Daniel Vlas
Systems Consultant