How to count # of Male/Female Entries on Report?

  • Thread starter Thread starter Bayou BoB
  • Start date Start date
B

Bayou BoB

Hello;

I have a report that is based on a query that generates some very
basic information for a client list.

Last Name, First Name, Date of Birth, Gender, Admission Date

Not a problem, that all displays wonderfully. At the bottom, I'm
trying to count the number of clients, and I've done that using the
'count' format. It totals as expected and desired.

The part that doesn't work, is where I'm trying to count the number of
males, and the number of females. How would I total this on the
report? Below is the example of what I'm trying to do:

Wilson, Pete, 10/05/58, M, 09/11/03
Mills, Wendy, 03/08/69, F, 10/10/02

Clients: 2
Males: 1
Females: 1


Thanks in advance!

Kevin
 
Count Males
=Sum(Abs([Gender]="M"))
Count of Females
=Sum(Abs([Gender]="F"))
Count of All
=Count(*)
These expressions can be used in a GROUP or REPORT FOOTER or HEADER.
 
Back
Top