Counting "yes" from multiple "yes/no" fields on single form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill_IDHEE - 28 May 2008 16:15 GMT

I know COUNT works across the whole database on a named field, but can it be
programmed to count the yes's from a number of different fields on the same
form?
I.E. to count how many of, say, 12 boxes are ticked.

Reply to this Message

Klatuu - 28 May 2008 17:24 GMT

Put a text box on your form to do that. Use the control's Control Source
property to count the number of check boxes that are checked. A check box
checked returns -1 and an unchecked check box returns 0, so you have strip
the sign bit of the results to return a positive number:

=Abs(CheckBox1+CheckBox2+CheckBox3+CheckBox4)

Signature

Dave Hargis, Microsoft Access MVP

> I know COUNT works across the whole database on a named field, but can it be
> programmed to count the yes's from a number of different fields on the same
> form?
> I.E. to count how many of, say, 12 boxes are ticked.

Reply to this Message