Problem with yes/no boxes

[winterh]

In one of my tables, we have single clients how can have six products and next to each product we have a tick box.What I want to happen is add all the Yes (ticks) up and take that figure away from the starting six products, the problem I have is access is counting every Yes (ticks) as -1.So if we have two Yes (Ticks) I gets a 0, which does not really help me :-)I am guess I must be able to change the properties of the Yes (Ticks) to stop this but I have no idea.

[June7]

Try using Abs function in the sum expression. Show your expression for analysis.

No, there is no property to 'change'. Access represents Yes/True with -1 and No/False with 0 in Yes/No datatype field.