Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Changing negative number to a positive number

Status
Not open for further replies.

maengler2000

Technical User
Feb 2, 2012
7
US
Using CR 2008.

I am trying to convert a negative number to a positive number. In other words, they want a -27 to show as +27.

I tried using "+" + totext (fieldname,0,"") but it is showing up at +-27.

Any suggestions.

 

Use the ABS() function.

Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top