Accounting Negative in a report

G

Guest

Hi everybody,

In a report I would like to show a negative number in the accounting format.
(10.00) as opposed to -10.00. Any suggestions?

Jones
 
G

Guest

on the format of the field on the report, try:

#,###.00;(#,###.00);\0

See "Format Property - Currency and Number..." in the help of Access for
more info

Hope this helps.
 
G

Guest

Jackie,

Spot on. Thanks for the help.

Jackie L said:
on the format of the field on the report, try:

#,###.00;(#,###.00);\0

See "Format Property - Currency and Number..." in the help of Access for
more info

Hope this helps.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Columnar Data To A Linear View In A New Table 7
Red cell for negative numbers in Excel 1
Total in Access report 1
How do I invoice a cost to a custom built MS Access Accounting Database? 0
match two conditions to return value from pivot table 1
Negative Number Formatting Excel 2007 1
separating out data in columns 2
Expense report error when entering a negative number 2

Top