counting 'yes' on a filtered form

  • Thread starter Thread starter Jeff @ CI
  • Start date Start date
J

Jeff @ CI

I have a form I filter for a particular event. I want to provide the user
with a list of people registered for the event in which they will confirm
whether they will still attend. I have provided several "yes/no" check boxes
for them to note their response. I need to then keep a running count on the
form for them to report their progress during the day. I intend to do this
on the form. I know to refresh the form after a checkbox is clicked,
however, when I count() I get the whole filtered recordset. I am trying to
find a way to count only those that are "True".

Thanks for your help in advance.

Jeff
 
Jeff

"How" depends on how your data (not your form) is structured.

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
These 9 fields are simple "Yes/No" fields pulled straight from the table. I
am not sure what all else you are looking for in structure.

Jeff
 
I got it figured out.

I created a text box (unbound) and instead of using count() - used
sum([fieldname]=True)*-1 as the control source. I initially went without the
multiplication but after realizing that I got a negative sum, used that to
make it more user friendly.

Thanks for the look.

Jeff
 
Back
Top