negative numbers

[hamdims]

How can I view -100 as (100) in ms access

Thanks

[puppydogbuddy]

How can I view -100 as (100) in ms access

Thanks

Not sure whether you are refering to the parentheses or the value

For showing parentheses in place of the negative sign:

For currency/number datatype fields, try placing >> 0;(0) << in the field or control's Format property.
__________________________________________________ ____________

For showing the value as a positive number, try using the absolute value function.

= ABS(-100)

[ADezii]

How can I view -100 as (100) in ms access

Thanks

You can use the built-in FormatNumber() Function for this, as in:

MsgBox FormatNumber(-100, vbFalse, vbFalse, vbTrue)

OUTPUT:

(100)

[alzowze]

To view any negative number as a positive number just multiply it by minus one.
eg... Select yourfield * -1 as theresult from yourtable.

hth...

Alan

[ADezii]

To view any negative number as a positive number just multiply it by minus one.
eg... Select yourfield * -1 as theresult from yourtable.

hth...

Alan

alzowze, the point was to view the Negative Number as a Positive Value within Parenthesis.