Sum Check Boxes

[Maxx]

In my test table, I have a field for checkbox set as number in the datatype. I have tried to add through queries the number of -1 and can't get it to count up. What am I doing wrong .. does Access not sum checkboxes? Thanks!

 

[pcs]

---you wrote------
In my test table, I have a field for checkbox set as number in the datatype.
------------------

i could be missing something here...but a checkbox is boolean, not a number. if you want a checkbox, change the field type in your table to Yes/No.

hth,
al