Count results from a query

[Clintimania]

I am working on a report that will count statistics. There are several check boxes that I want to count the number of "yes" checks. So I made a report, then put this code in an unbound box...

=IIf(([Case Opened]=Yes),Count([Case Opened]))

Well instead of only counting the yes checks, it counts them all. What am I missing?

 

[Brianwarnock]

Counts can give unexpected results, but in this case as a Yes is actually -1

=abs(sum([case opened])) should do the trick

Brian

 

[Clintimania]

Wow... abs.. I will look that up... because it worked! Thank you!

 

[Brianwarnock]

Don't you just love it when you make somebody happy.

Yes Abs is good.

Brian