counting the yes's

  • Thread starter Thread starter indians
  • Start date Start date
I

indians

I created a form and I am now trying to set up a report.
I used check boxes as options and I would like find out
how many of each option were used. Are using check boxes
the best way or is there a better way? What if I used a
drop down box? Is there a way to get a total number of
each option? and how? Thanks!
 
indians said:
I created a form and I am now trying to set up a report.
I used check boxes as options and I would like find out
how many of each option were used. Are using check boxes
the best way or is there a better way? What if I used a
drop down box? Is there a way to get a total number of
each option? and how? Thanks!
Click to expand...


Check boxes are fine for this.

You can count the number of checked true values in the
form's record source by using a text box in the form's
header or footer section. Set the text box's control source
expression to something like any one of these:

=Count(IIf(yesnofield, 1, Null))
or
=Sum(IIf(yesnofield, 1, 0))
or
=Abs(Sum(yesnofield))
 
Back
Top