Report Query

[Guest]

I have a database that has 4 fields. It has an incident number, an agency,
the sex of an individual, and the section an individual belongs in. I am
trying to create a report that gives me the number of individuals in an
agency and the number of male and female indivduals in a section. So for
example, it should look something like this:

Agency Section
Total

DNR Plans Finance
Males Females Male Female

3 2 1 3
9


Any ideas on how to do this?

 

[Duane Hookom]

Have you considered creating a crosstab query to get your information
together in this format? You could use a column heading expression like:
ColHead: [Section] & "_" & [Sex]