Creating a counter to count "yes" responses of Combo Boxes?

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

Guest

I created a sub-form w/ several text-boxes that serve as counters for
particular check boxes from my main data entry form. So, using
=Abs(Sum([Field_Name])) as the control source for each of the sub-form’s 7
individual text-boxes I’m able to open this sub-form and in one glance I’m
able to get a summary count of each of these 7 variables (check boxes).

That being said, I’d like to create another sub-form that counts 8 other
variables…except that I’ve used “Yes/No†combo boxes on my main data entry
page…so, (The user answers “yes/no†to a series of 8 questions)…in any case
the above formula does not seem to work…for counting these combo box
results…is there some variation of the aforementioned formula that should
provide me with 8 totals? (e.g., how many users responded yes to item #1, and
so on to item #8)
v/r
Steve
 
Thank you sir...that did the job...

Steve Schapel said:
Steve,

Try it like this...
=Abs(Sum([Field_Name]="yes"))

--
Steve Schapel, Microsoft Access MVP
I created a sub-form w/ several text-boxes that serve as counters for
particular check boxes from my main data entry form. So, using
=Abs(Sum([Field_Name])) as the control source for each of the sub-form’s 7
individual text-boxes I’m able to open this sub-form and in one glance I’m
able to get a summary count of each of these 7 variables (check boxes).

That being said, I’d like to create another sub-form that counts 8 other
variables…except that I’ve used “Yes/No†combo boxes on my main data entry
page…so, (The user answers “yes/no†to a series of 8 questions)…in any case
the above formula does not seem to work…for counting these combo box
results…is there some variation of the aforementioned formula that should
provide me with 8 totals? (e.g., how many users responded yes to item #1, and
so on to item #8)
v/r
Steve
Click to expand...
Click to expand...
 
Back
Top