Report Sum Help!!!!

[sysop470]

I have a report which includes the MALE and FEMALE as gender.

I have made this =Sum(IIf([gend]="M",1,0)) which sum all the MALE. It works but my problem is if there is duplicate person in the report, it would sum as 1 MALE not 2,3 etc tec

Any help pls.
Thanks

 

[Ziggy1]

I do something like this. I place a control in the detail section, and make it invisible (leave visible for testing). Then use an expression like...

=IIf([gend]="M",1,0)

The running Sum property of this control is set to "Over Group"

Then in the report footer (don't use page footer for Calcs), you simply put the name of the control in a text box control source eg... =[Text2] this refers to the results of the control above...because it is a running sum it returns the last total which will be your "Count".

 

[sysop470]

Thanks for your help but it does not work...

 

[boblarson]

Thanks for your help but it does not work...

Are you wanting to just count ALL male / female in the table, regardless of whether they are duplicates of the same person?

The way that was shown to you SHOULD work, but you could also look into using a DSum.