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!

---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

Use the Sum() function rather than the Count() function and surround it with the Abs() function to display a positive number rather than a negagive one.

Abs(Sum(YourBoolean)) As YourCount