make SUM negative in query?

JCross

Registered User.
Local time
Today, 20:27
Joined
Feb 28, 2002
Messages
116
Hi all,

I have a field in a query:

Count: Sum((Nz([Qty],0)))

and I want the equation to make the result NEGATIVE. is there a way I can do this?

Thank you for your help today, and everyday
smile.gif


Jennifer
 

Users who are viewing this thread

Back
Top Bottom