Change a negative number to a positive

G

Guest

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

Wayne Morgan

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

Abs(Number)
 
A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top