Count code on reports

sladetroityer

Registered User.
Local time
Today, 06:06
Joined
Oct 26, 2011
Messages
149
I am trying to count the number of classification types for employees in a report. The types are NBU, SBU, CON, SRA, and HBU. Each employee has a classification and when I run the count code on a report it's counting ALL employees with a classification. I want to count the employees that have only NBU as thier classification. From there I will also count the SBU's, HBU's, and so on and so forth.

Will the count code work in this instance?

Please help!
 
Code:
=Count(IIf([Classification] = "NBU", 1, Null))
Or use the DCount() function.
 
That worked wonders..... Thanks....VBAInet
 
Now all I have to do is figure out how to filter the reports.......Uggh. I really wish I knew how to get you the code required to get help on that other thread from yesterday!
 
All explained in my posts. Re-read it again and look at the link.
 

Users who are viewing this thread

Back
Top Bottom