counting up items in row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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)
 
Back
Top