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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
Excel VBA - counting cells by colors and names to it in two different rows. 0
Lookup current record with ComboBox, any changes create new record 3
record count from system 3
Need combo box to refresh when moving to new record 2017 1
Total filtered record count on filtered adp form 1
Access Dcount function in access 0
Count specific combobox records in sunform 3

Back
Top