Abs() Function

[PR2AledE]

Abs( )Function

Can anyone tell me what a Abs() function is and how I can use it in a query field to change negative values into positive values.

Thanks

 

[Rich]

Go back and read the answer given.
Please stop multiple postings, if you don't understand the answer go back to the original thread and say so

 

[jfgambit]

From the Access help files:

ABS
Returns the absolute value of a number, which is a number without its sign.

Syntax

ABS(number)

Number is the number whose absolute value you want.


Add the following to convert the Negative to positive:

Abs([YourFieldHere])


HTH

 

[Rich]

jf, he's already had this answer, either he can't read or is spamming

 

[jfgambit]

Yea...sorry about that Rich...just got on-line and this was the first post I looked at (Search New Posts)...next time I'll scan the whole forum.

Do you think I should post this 3 other places, just to make sure that others see it??

 

[Rich]

Suddenly the Mod bit doesn't seem so unattractive

 

[Mile-O]

Simply put: ffs