Link to home
Start Free TrialLog in
Avatar of SteveL13
SteveL13Flag for United States of America

asked on

How display negative number as a positive number

I have a report that will always display a number as a negative value (example:  -125,235)  How can I force the report to show these numbers as a positive number.  (125,235)
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

ABS(-125,235)  = 124.235

mx
ASKER CERTIFIED SOLUTION
Avatar of als315
als315
Flag of Russian Federation image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Absolute Value Function ...

ABS()

mx
Avatar of SteveL13

ASKER

Sorry, the number I used is just an example of the numeric value.  The actual field control souce is [Net].  So then what would the syntax be?
the OP doesn't just want the positive #, they want to use an accounting format, which wraps the negative number in parenthesis.

so maybe:

=IIF(sgn(MyValue) = -1, "(" & abs(MyValue) & ")", MyValue)

Steve ... I posted the exact same answer ... First ...using the ABS function

mx
"The actual field control souce is [Net].  So then what would the syntax be?"

>>> @ http:#a37026240