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