counting 'yes' on a filtered form

[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 Boyce]

Jeff

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

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff @ CI]

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

 

[Jeff @ CI]

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