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

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
Negative Numbers 5
Importing *.txt file containing negative numbers 4
Negative numbers 5
Report Ignoring negative numbers 7
Word 2007 Equation - How do I insert a negative number symbol? 1
Negative number format 5
Excel 2007 - display negative numbers with minus sign and parenthe 3

Back
Top