How to display a negative # as positive - Abs

[bethabernathy]

Hi - I have a query with a field named "othrsr", which returns both positive an negative numbers. I want to return all the negative numbers as positive. I try adding "Abs([othrsr])" into the criteria and that restricts the data set to only positive numbers is there a way in the query to turn all the negative numbers to positive? Or should I do it in a report? Any information is really appreciated.

Thanks, Beth beth@integratedresourcemgmt.com

 

[cmmrfrds]

I don't know about a function to do it, but in the old days (pre 90's) we used to multiply by -1 to convert to positive. if num < 0 then num = num * -1.

 

[RichUK]

You have to put the expression into the grid Expr1:Abs([MyField]) or as the control source for a text box on your report.