Convert Neg Values to Positive

[creativefusion]

Hi All,

I have a field in a query called TOT_DMD and it has all values displayed in negative numbers.

I want to display them all in Positive numbers.

Can someone help me with converting them all to Positive numbers?

Thanks
CF

 

[Galaxiom]

Abs(TOT_DMD)

This will return all values as positive.

 

[creativefusion]

Thanks Galaxiom.

Works fine.

Have a good evening.
CF

 

[DCrake]

Another solution is

Amt = Amt*-1

Turns neg to pos and pos to neg

David