View Full Version : make SUM negative in query?


JCross
04-04-2002, 04:00 PM
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 http://www.access-programmers.co.uk/ubb/smile.gif

Jennifer

Pat Hartman
04-04-2002, 06:49 PM
Count: Sum((Nz([Qty],0))) * -1

JCross
04-05-2002, 07:35 AM
Thank you, Pat.

Jennifer