count in report

[clcnewtoaccess]

I can create a count on a field in a report but is there a way to force it to
only count specific names from that field.
Example: the field is tool_code which has up to 50 different tool codes
such as HF, HB, STFB, NCT...... and I only want the count of NCT's to show
up in my report.

Hope this makes sense!

 

[Wayne-I-M]

=Count(IIf([FieldName]="NCT",1))

 

[fredg]

I can create a count on a field in a report but is there a way to force it to
only count specific names from that field.
Example: the field is tool_code which has up to 50 different tool codes
such as HF, HB, STFB, NCT...... and I only want the count of NCT's to show
up in my report.

Hope this makes sense!

=Sum(IIf([ToolCode]="NCT",1,0))