Count code on reports

[sladetroityer]

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!

 

[vbaInet]

=Count(IIf([Classification] = "NBU", 1, Null))

Or use the DCount() function.

 

[sladetroityer]

That worked wonders..... Thanks....VBAInet

 

[vbaInet]

You're welcome!

 

[sladetroityer]

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!

 

[vbaInet]

All explained in my posts. Re-read it again and look at the link.