count in report

  • Thread starter Thread starter clcnewtoaccess
  • Start date Start date
C

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!
 
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!
Click to expand...

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