Summing True value Yes/No Checkboxes in a Report

[Guest]

I have a yes/no checkbox in one of my reports. At the end of the report I
want to do a Sum for each checkbox that is checked. I can't figure out how
to do this. Is it possible and if so how?

 

[Rick B]

Have you searched the help files, or previous posts in the newsgroup? This
is very very common.

Search for your answer.

 

[Roger Carlson]

Yes/No fields store numeric values: -1 for Yes, 0 for No. So if you want to
sum the Yes values, simply sum the field and take the absolute value. For
instance in a text box, use
=Abs(Sum([MyYesNoField]))

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L