Convert Negative Values to Positive

[creativefusion]

Hi All,

I have a query that displays all records in negative values.

Can someone please tell me how I can convert them all to positive values?



i.e. Column value is -76000 expected result is 76000

Thanks.

[dcrake]

Two methods

Abs(<<Value>>)

Or

X = Y*-1

David