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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Woody said:
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
Click to expand...

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
 
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)
 
Back
Top