Acces Reports

  • Thread starter Thread starter Thel
  • Start date Start date
T

Thel

I have a report that is built from a query, I would like to total the number
of Females , and the number of males in the gender field by department and a
grand total.
Females =12
Males = 9
 
I have a report that is built from a query, I would like to total the number
of Females , and the number of males in the gender field by department and a
grand total.
Females =12
Males = 9
Click to expand...

How is that information stored in your table? What is the structure of your
report? Where do you want this count to appear?

I'm GUESSING you could base the report on a query with two calculated fields:

IsFemale: IIF([Sex] = "F", 1, 0)
IsMale: IIF([Sex] = "M", 1, 0)

and total these fields in the form or group footer.
 
Back
Top