How do I count selected data in a report footer

[Guest]

Am attempting to count the number of conditions in a data field [status] with
a certain stated value; in a group summary and then a report summary (i.e.
count the Number of records where the data in [status] equals a descriptive
value such as “Widowâ€, “Activeâ€, or “Retiredâ€).

 

[John Spencer]

Just as Douglas Steele said in the earlier posting, use something like
the following for the control's source

=Abs(Sum([Status]="Widow"))

You will need a control for each status and, obviously, you will need to
change the value you are looking to count.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================