Counting based on criteria

[Jim Williams]

I'm creating a report for a training tracker that will display a count
of the number of scores for a class that are passing and non-passing.
I try to tell it to count the number of scores =>80 and vice versa,
however nothing seems to work. Can anyone point me in the right
direction?

Thanks!

 

[John Spencer]

In a control use the following expressions to get a count.

=Abs(Sum(Scores>=80))

and

=Abs(Sum(Scores<80))

You could also use

=Count(IIF(Scores>=80,1,Null))
and
=Count(IIF(Scores>=80,Null,1))

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Jim Williams]

John,

Thank you SO much! I added that, and it makes my life so much easier.
I've integrated it into my query, and now I'm going to a little more
research so I actually understand how it works

Regards,

Jim