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
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
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)
Just wanted to be consistent in the results. Thanks for responding