Negative Number formatting

[Guest]

Hi all,

Quick question. I have a calculation in a query, and I want the negative
returns to display with paranthesis. How do I do this in access?

 

[Guest]

Hi Schnydes,

Try the following in the Field row of the query grid:

Product: Format([Field1]*[Field2],"0;(0)")
or
Product: Format([Field1]*[Field2],"0;(0);;""Null""")

if you want the word "Null" to be displayed if either Field1 or Field2 is
null. Replace Field1 and Field2 with the actual names of your fields.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

Hi all,

Quick question. I have a calculation in a query, and I want the negative
returns to display with paranthesis. How do I do this in access?