MS Access Query not including negative number

[shank]

I have the below data. I'm not able to include the -1 in the sum.



SoldQty: Sum([PA Reports]![SoldQty]) = 2
Obviously, it should = 1

I tried SoldQty: Sum(Abs([PA Reports]![SoldQty])) = 2
Same difference.

What am I doing wrong?

Data:

StoreNo	SoldQty
014	1
026	-1
031	1

Thanks!

[shank]

Ugh! Found it. Never mind.