Counting the Text-values of Fields in Report (1 Viewer)

[russi]

Help.
I have fields that must contain text values such as MALE , FEMALE, ...
I need to make reports which will add the number of records that have a given value (i.e., How many FEMALES)
I am lost on how to do this. I have tried unbound text boxes in both detail & footer sections, but get error messages when even entering the '=' sign to write an expression.
HELP. Please. Thanks!

 

[Pat Hartman]

The following query will produce the counts you need. You can use it as the recordsource for a subform you place in the report footer of the main report.

Select SexCode, Count(*) AS CountOfSexCode
From YourTable
Group By SexCode;