sum of checkbox issue

[M.McDoom]

Hello,


I am attempting to get the sum of several checkbox categories in my
report. I do not want the negative values that MS Access recognizes,
Instead I want positive values. I have based my report on a query in
which I used the total function for the checkboxes for several
different sites. I used the following in the property box of my
report.

=ABS(Sum([SumOfPolicy]))

But I continue to get the Sum of the Sum, In other words instead of
getting the sum of the number of policies at one site it gives me the
sum of the policies for all the sites.

All I want is the sum of the policy for each individual site as a
positive number.

Thanks for any help.

 

[M.McDoom]

In addition even if I try =Abs(Sum([Policy])) I still get the aggregate
Sum for all the sites instead of the individual sites.