Form Control

[neilmcmor]

I have a form that has a check box, (Attended), ticked if a condition is true. I have placed a text box on the form to count the ticks. I have tried various expressions in the control for the text box but it continues to count the all check boxes whether ticked or not. I tried something like the following in the control.

=Count([Attended]=Yes)

Can anyone help

 

[ShaneMan]

I have a form that has a check box, (Attended), ticked if a condition is true. I have placed a text box on the form to count the ticks. I have tried various expressions in the control for the text box but it continues to count the all check boxes whether ticked or not. I tried something like the following in the control.

=Count([Attended]=Yes)

Can anyone help

Have you tried:
=Count([Attended]= True)

HTH,
Shane

 

[neilmcmor]

Yes I have tried that but it still returns same value. Thanks anyway

 

[boblarson]

Use this instead:

=Sum(IIf(Nz([Attended],0)=-1,1,0))