absolute value

[wdbouk]

Hi all,

I am wondering how to calculate the absolute values in access. I have a huge database and I want to transform negative number to positive ones.
Thanks

 

[RoyVidar]

Since this is the tables and relationship forum, I'm not entirely sure what to answer, but if you're contamplating doing this through coding or queries, I'd take a look at the ABS() function:

Roy-Vidar

 

[PHV]

I want to transform negative number to positive ones
UPDATE yourTable SET yourField=-yourField
WHERE yourField<0;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244