Re: How do I count tick boxes in Access?

Are all the Tick Boxes in one row or do you want to count the number in a
field in a set of records?

Tick boxes are yes/no fields and have the value of -1 or 0. So to "count"
the ones that are checked you can do the following:

Field: CountInRow: Abs(CheckBox1 + CheckBox2 + CheckBox3 + CheckBox4)

If you want to count them in one field across many records (rows) then you
can use a summary query and sum them

Field: Abs(Checkbox1) as CountChecks1
Total: Sum


"Nat" <Nat@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1B429A0E-64E0-4C57-A3FE-1A651041693C@xxxxxxxxxxxxxxxx
I have a number of tick boxes which are filled and a number that are empty.
I wish to count the checked ones and need help with the how.


.