Turning negative number to positive

[slimjen]

Gm. Using access 2016. I need to change a field that has negative numbers to positive numbers. Is the best way to do this is to use abs? I don't want to receive mixed results. Is there another way to do this other than using absolute? ? Thanks

[CJ_London]

abs returns all numbers as positive

abs(1)=1
abs(-1)=1

what is your concern about mixed results? you either want all numbers to be positive or you don't

If you want an alternative I guess you could use the iif function

iif(mynum<0,mynum*-1,mynum)

[slimjen]

Just wanted to be consistent in the results. Thanks for responding