Changing the negative sum of checkboxes

[EthanVos]

Good evening all.

I have a simple table with 20 or so fields that are check boxes. I use the sum in a query but I get a negative number for the sum because the check is -1. The number is correct, just negative. How can I make this a postive number in my report?

Thanks.

Ethan

 

[VBslammer]

Use the Absolute function:

   Debug.Print Abs(-20)
   20

VBSlammer

Unemployed in Houston, Texas