Why does my query equation have a - in front of the return?

[Guest]

Why does my query equation have a - in front of the return? How do I stop
this? The numerical answer is correct however, I want it to show a
"positive" number in the return

 

[Tom Lake]

Why does my query equation have a - in front of the return? How do I stop
this? The numerical answer is correct however, I want it to show a
"positive" number in the return

If it's doing a subtraction, you have it backwards. In any case, use Abs(n)
to get the Absolute value (minus sign removed)

Tom Lake

 

[Van T. Dinh]

Post relevant details of your Table(s) and the SQL String of your Query. It
is pretty hard to see what's wrong with minimal details.

HTH
Van T. Dinh
MVP (Access)