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

[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

 

[Duane Hookom]

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.

 

[Bayou BoB]

Works great! Thanks Duane!