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

W

Woody

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
 
T

Tom Lake

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
 
V

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