Count

  • Thread starter Thread starter Roy
  • Start date Start date
R

Roy

I have a report with several categories. I wish to total
the number of a specific category that does not apply to
each record. When I use =Count([Item]), the report
totals all records, not those rows with information in
the "Item" Column. Help!
 
I have a report with several categories. I wish to total
the number of a specific category that does not apply to
each record. When I use =Count([Item]), the report
totals all records, not those rows with information in
the "Item" Column. Help!
Click to expand...

You haven't been especially clear, but perhaps you can adapt this
method of counting.

To count those that do not = the criteria:
=Sum(IIf([ControlName]= "Criteria",0,1))

Or conversely to count how many do = the criteria:
=Sum(IIf([ControlName]= "Criteria",1,0))
 
Back
Top