counting up items in row

L

LU

I have about 10 Yes/No columns in table. In my form when I go from record to
record I want to count the number of yes for per record. So if the 1st row
has 4 yes, then on my form I will see the total of 4.

How can I get this done?
 
D

Duane Hookom

Add a text box with a control source of:
=Abs(YesNoCtrl1+YesNoCtrl2+YesNoCtrl3+YesNoCtrl4....)
This assumes the values of the yes/no fields are not null. If there is a
chance of Null values, use
Nz(YesNoCtrl1,0)
 
Top