convert values (1 Viewer)

[Moktar]

Hello guys!
one of my tables has column contains positive and negative numbers(currency). do you know how to make it all positive numbers?

if i try to multiply -1 then the positive numbers would convert to negative and i don't want that.

Thank you!

 

[pbaldy]

Check out the Abs() function.

 

[Moktar]

Check out the Abs() function.

can you explain it please. i know how to use that on excel but not on access. when i try abs function it requires a number but i wanna apply it on the whole column.
thank you!

 

[pbaldy]

I doubt you could use it on an entire column in Excel either.

You'd use it in a query, form, or report, depending on your exact goal:

Abs(FieldName)

If you want to actually change the values in the table, use it in an update query.

 

[plog]

Perhaps you can explain the ultimate aim of this step. What's the big picture of what you are trying to accomplish?

From your initial post Abs() is absolutely what you want. But now with your follow up its sounds as if you are new to the database world and the ultimate aim is unclear to us. Let us know the big picture and we can help you get there.

 

[Moktar]

Thank you guys!! I used ABS function in update query as you guys told me and worked!
yes I am new to Database world .

 

[pbaldy]

Happy to help and welcome to the site by the way!