Re: Groups in access report

[phillbaker]

Re: Groups in access report

i have a query which is listing all the clients that are male and female and also if they have a disability and also there ethnicity.

What i want to show is below:

Male = Total Number
Female = Total Number
Disbilty = Total Number
List of All Ethnicity's and how much of each one beside them.

How is best to do this.

 

[pbaldy]

Re: Groups in access report

For gender and disability, textboxes in the report footer:

=Sum(IIf(GenderField = "M", 1, 0))

For ethnicity, because of the variable nature of them, I'd use a subreport based on a totals query that grouped on ethnicity and counted them up.