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

Abs(TOT_DMD)

This will return all values as positive.

Thanks Galaxiom.

Works fine.

Have a good evening.
CF:)

Another solution is

Amt = Amt*-1

Turns neg to pos and pos to neg

David