change sign (positive or negative) in select statement

[willkr]

I have a table where a certain field is always negative, but in a form I always want to display it as positive. How do I do that. Let's assume the select statement is:

SELECT Table.Field from Table



Do I have to change the SELECT statement or is there something I can do in the text box?

[Welshgasman]

Multiply by -1?

[willkr]

Never mind, I figured it out

[Minty]

I would use the Abs() function, in case you also have positive value ever entered.

SELECT ABS(Table1.Field) as PosNumber
FROM Table1

https://support.microsoft.com/en-us/...f-f4636dab9563

[Welshgasman]

Never mind, I figured it out

Too late, I already answered?
Minty's solution would be best if it could EVER be positive, but you said it could not?

[CJ_London]

Or you can just use the format property