Negative Value When Counting Yes/No

[Windsor302]

Hey guys, I need to calculate the percentage of rejected. I have a column for accept and one for reject. I want it to count when true in accept and reject, when i try this it shows up as a negative value? Any idea what i doing wrong? Thanks.

 

[CBrighton]

Are you sure you are counting rather than summing?

 

[gemma-the-husky]

access actually stores yes = -1 and no = 0

so you are probably summing, and the value you get is the number of true values, surprisingly.

 

[JANR]

Access stores True as -1 if you want to sum all true's then wrap the Field with ABS() function to convert to positive numbers

ex

Sum(Abs([Yes/No Field]))

JR

 

[CBrighton]

Or just

Count([Field])

 

[Windsor302]

Thanks for the input, I am summing because when i tried counting it just counted every box checked or not.

 

[CBrighton]

Thanks for the input, I am summing because when i tried counting it just counted every box checked or not.

Good point, well spotted. Not sure how I missed that!