iif problem

[Guest]

Hi there,

In my report, my data looks something like this:

Group 1 M 10
F 8
Group 2 M 12
F 10
etc

I have tried to get a text box to add up just the Males and of course I will
need another one to add up just the females.
I have tried the following:
=IIf([Gender]="m",Sum([GenderCount]),0)
[Gender] of course is the middle column and [GenderCount] is the actual
number. I end up getting a total for the entire group and not the specific
gender. What am I doing wrong here or can someone suggest something else?
Thanks,

John

 

[fredg]

Hi there,

In my report, my data looks something like this:

Group 1 M 10
F 8
Group 2 M 12
F 10
etc

I have tried to get a text box to add up just the Males and of course I will
need another one to add up just the females.
I have tried the following:
=IIf([Gender]="m",Sum([GenderCount]),0)
[Gender] of course is the middle column and [GenderCount] is the actual
number. I end up getting a total for the entire group and not the specific
gender. What am I doing wrong here or can someone suggest something else?
Thanks,

John

=Sum(IIf([Gender]="m",[GenderCount],0)
=Sum(IIf([Gender]="F",[GenderCount],0)

 

[Guest]

Hey, thanks that was really helpful!

JR
--
www.brightfuture.ca/bright
My email address can be found on my site.

Hi there,

In my report, my data looks something like this:

Group 1 M 10
F 8
Group 2 M 12
F 10
etc

I have tried to get a text box to add up just the Males and of course I will
need another one to add up just the females.
I have tried the following:
=IIf([Gender]="m",Sum([GenderCount]),0)
[Gender] of course is the middle column and [GenderCount] is the actual
number. I end up getting a total for the entire group and not the specific
gender. What am I doing wrong here or can someone suggest something else?
Thanks,

John

=Sum(IIf([Gender]="m",[GenderCount],0)
=Sum(IIf([Gender]="F",[GenderCount],0)