How do I restrict count of records if = to certain words

  • Thread starter Thread starter Judy
  • Start date Start date
J

Judy

My report has all the records, but I need to run some over all counts where
only certain conditions exit. Example, of all the records in the report,
count only those with field xyz that has conditional formatting that is "red"
or that has certain key words. Example - count policy type where policy type
is "whole life".
 
Set the controls source to

=ABS(Sum([policy type]= "Whole Life"))

This works because [policy type]= "Whole Life" is going to return True
(-1) or False (0). Summing that will return a number. The ABS function
will strip off the negative sign.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
Back
Top