counting check boxes

[MPH03]

HI !! Did not type correct subject.....trying it again.. I am trying to total the number of yes checked boxes on my report in the footer, only want to total the number of checked...do not want total not checked....my current expression is:
=Sum([field name])....but it is not calculating correctly...can I do what I want to do with check boxes... thanks !!!!

 

[PaulBricker]

You can use this
=Abs(Sum([FieldName] = -1))
This will total Yes'


Paul

 

[THWatson]

Hi, Paul
I was just about to answer this with something I pulled off the Microsoft Knowledge Base, article 209505.

The function that I worked out following reading that article is =Sum(IIf([Check]=True,1,0))

Why do check boxes not respond to the Count function?

Tom

 

[PaulBricker]

Hi Tom. As far as I know, it doesn't matter whether it's a textbox or checkbox, neither will respond to the Count function if you are testing for a specific value probably because they return a boolean value and the count function doesn't know what to do with a boolean where Sum() does. I started using the
Abs(Sum([Check2] = -1))
instead of the expression you have just because it's a little shorter. I picked it up reading some dhookum and CosmoKramer posts.

Paul

 

[THWatson]

Thanks, Paul. Makes sense.
Tom