Changing neg to pos numbers in an update query

S

Stu

In my table, Field10 is full of negative numbers. I want to change them top
positive numbers in an update query. In the Update To: I have [Field10]*(-1)
has no effect. What's the easiest way? (no code please)
 
S

Stu

Works! - Thanks!

Ofer said:
Try

Abs([Field10])

--
Please respond to the group if your question been answered or not, so other
can refer to it.
Thank you and Good luck



Stu said:
In my table, Field10 is full of negative numbers. I want to change them top
positive numbers in an update query. In the Update To: I have [Field10]*(-1)
has no effect. What's the easiest way? (no code please)
Click to expand...
Click to expand...
 
J

John Spencer

Are you running the update query or simply switching to datasheet view? You
must run the query to have any result. (Select Query Run from the menu or
click on the Red Exclamation button)
 
Top