Change a negative number to a positive

[Guest]

How do I change a negative number example -524.50 to a
positive number field 524.50 in access 97

 

[Rick B]

=Abs([somefield])

 

[Wayne Morgan]

Use the absolute value function. It will always return a positive value or
zero.

Abs(Number)

 

[Asmodeus]

How do I change a negative number example -524.50 to a
positive number field 524.50 in access 97

Run an update query and multiply it by -1.

--
"It's better to be a red person in a blue state than a blue person
in a red state. As a red person, if your blue neighbors turn into
a mob at least you have a gun to protect yourself. As a blue person,
your only hope is to try to appease the red mob with herbal tea and
marinated tofu."
--Phil Garding