how do I remove a minus sign from a negative number in access?

G

Guest

I have negative numbers in my data that I need to use the positive value of
to create a report. Is there a way to simply remove teh minus sign?
 
A

Andi Mayer

I have negative numbers in my data that I need to use the positive value of
to create a report. Is there a way to simply remove teh minus sign?
Click to expand...

ABS(the Value)
gives you the absolute Value of the Value and this is evertime
positive
 

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

Similar Threads

Change values to negative amounts? 3
Report Ignoring negative numbers 7
Importing *.txt file containing negative numbers 4
Negative numbers 5
Matching Negative and Positive Values 20
Negative number format 5
Word 2007 Equation - How do I insert a negative number symbol? 1
Excel 2007 - display negative numbers with minus sign and parenthe 3

Top