Hi, i have 10 checkboxes on a report on access 2003. I want to be able to count how many of these are not checked and display this in a text box.

e.g

Checked=4

Unchecked=6

So the box would return "6"

I have tried some CountIf functions but its been years since i have used them and i've either got a bit rusty with them or am doing it completely wrong.

Thanks in advance

---

Answer from Richard Rost:

If these checkboxes are all FIELDS in the same RECORD, then you can create an unbound textbox with the following formula as the Control Source:

=(Box1+Box2+Box3)*-1

You'll obviously want all 10 boxes in there (Box1 is the name of your first checkbox, et al.)

You'll then multiply that result by -1 because a YES checkbox is given the value of -1 (a NO gets 0). So just add them all up and negate it.

Easy enough?