Changing neg to pos numbers in an update query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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...
 
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)
 
Back
Top