Hiho!
Quick and probably easy question..
When I use the Abs([FieldName])
Is there a way that I can show the abs value both negative and positive?
Right now if the Abs value is negative it sets it to positive on its own!
Hiho!
Quick and probably easy question..
When I use the Abs([FieldName])
Is there a way that I can show the abs value both negative and positive?
Right now if the Abs value is negative it sets it to positive on its own!
Can you tell us what the context is? Give an example of WHAT you want.
You could try MyString = "+/- " & Abs(YourVariable)
Abs will give you the numeric value o the variable/expression regardless of sign.
http://www.techonthenet.com/access/functions/numeric/abs.php