Need to count check boxes without getting negative numbers

[Guest]

I have a query that only singles out my boxes that are checked. But all the
numbers are -1. I know that's how Access recgonizes True, but now that I'm
building my report I have -1,-2,-3. How do I just have it count positive not
negative?

 

[JR]

Hi,

Not sure if this is what you want?

SELECT Sum(IIf([YourFieldName]=-1,1,0)) AS [Positive Count]
FROM tblTestData;

Returns a count of all records where your true/false field was true.

JR

 

[Marshall Barton]

I have a query that only singles out my boxes that are checked. But all the
numbers are -1. I know that's how Access recgonizes True, but now that I'm
building my report I have -1,-2,-3. How do I just have it count positive not
negative?

Put a minus sign in from of the expression or use the Abs
function.