Converting negative values to positive

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

Hello,

I have a table of Sales Orders. In the table the quantity
field reflects negative values that is outgoing stock,
which is correct. I need to convert those negative values
to positive values for other calculations but negatives
will not work. Any assitance on this is much appreciated.

Thanks in advance!

Tony
 
Tony said:
Hello,

I have a table of Sales Orders. In the table the quantity
field reflects negative values that is outgoing stock,
which is correct. I need to convert those negative values
to positive values for other calculations but negatives
will not work. Any assitance on this is much appreciated.
Click to expand...

Where are you doing these calculations? If you're doing them in a query
you can just use the minus operator (-) to flip the sign of the Quantity
field; for example:

ExtendedPrice: -Quantity * Price

If you're using VBA code you can do pretty much the same thing:

ExtendedPrice = --Quantity * Price

If that doesn't nswer your question, I'm afraid you'll have to explain
in more detail where the problem is.
 
Back
Top