bethabernathy
Programmer
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
Thanks, Beth beth@integratedresourcemgmt.com