Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 550
  • Last Modified:

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)
0
SteveL13
Asked:
SteveL13
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
ABS(-125,235)  = 124.235

mx
0
 
als315Commented:
You can use
abs(MyValue)
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Absolute Value Function ...

ABS()

mx
0
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
SteveL13Author Commented:
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?
0
 
Dale FyeCommented:
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)

0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
=ABS([Net])

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Steve ... I posted the exact same answer ... First ...using the ABS function

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"The actual field control souce is [Net].  So then what would the syntax be?"

>>> @ http:#a37026240
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now