Change Minus Values into Plus Values

[PR2AledE]

I have added all the true values in a field in a query is it possible to change these values from negative values into positive values.

 

[Mile-O]

The Abs() function.

 

[Mile-O]

From Access Help:

The ABS Function

Returns a value of the same type that is passed to it specifying the absolute value of a number.

Syntax

Abs(number)

The required number argument can be any valid numeric expression. If number contains Null, Null is returned; if it is an uninitialized variable, zero is returned.

Remarks

The absolute value of a number is its unsigned magnitude. For example, ABS(-1) and ABS(1) both return 1.

So, by using the absolute value of the value you wish to put in it:

Abs(minus value of your total) is going to be positive value of your total.

You can look up the examples on the Help, too.


P.S. Could you please delete the other post you made as there was no reason to start a new thread?