Need to convert Positive to Negative

[kmclane]

I have a report where I post the result of a query. The problem I have is that the query returns a positive number, and I need to post it as a negative number. It is going in an income section so I want it clear that it is reducing income not increasing it. I'm just not sure how to go about changing it. Thanks, Ken.

- If you are flammable and have legs, you are never blocking a fire exit.
Mitch Hedburg

 

[BobJacksonNCI]

(your query) * -1


HTH,
Bob

 

[CajunCenturion]

To guarantee a negative results, I would do the following:

Value = -1 * (Abs(Value))


Good Luck
--------------
To get the most from your Tek-Tips experience, please read FAQ181-2886
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein