Counting "yes" from multiple "yes/no" fields on single form

[Bill_IDHEE]

I know COUNT works across the whole database on a named field, but can it be
programmed to count the yes's from a number of different fields on the same
form?
I.E. to count how many of, say, 12 boxes are ticked.

 

[Klatuu]

Put a text box on your form to do that. Use the control's Control Source
property to count the number of check boxes that are checked. A check box
checked returns -1 and an unchecked check box returns 0, so you have strip
the sign bit of the results to return a positive number:

=Abs(CheckBox1+CheckBox2+CheckBox3+CheckBox4)