counting ages

[LaughingBull]

I have a report that groups the program a person attends and then the ethnicity is grouped. in the detail is the sex and age group for the person. what I want to do is place the count of male or female and the different age group totals on the report footer.
the report data source is a query of the info.
it would be if statements like if age group =1 then count age
if age group =2 then count age
if age group =3 then count age
if sex = 1 then count sex
if sex =2 then count sex


is sex =3 then count sex
age group has its' own table
on the main table age group is a lookup from the age group table
I want 6 different expressions in the query to show the totals.
I am not sure how to use the expression builder to create these iif statements, can you help?

[NTC]

Not knowing the structure of your data one can't give specific advice. But I would say in general you should establish/calculate your various counts using queries. Then consider the report object as the vehicle to display that data. Rather than considering the report object as the place to calculate the data. Hopefully this helps approach it. You may end up with a series of sub reports. I have certainly done that in the past.