Group:  Microsoft Access ยป microsoft.public.access.reports
Thread: Is there a bracket (financial) format?

Is there a bracket (financial) format?
8020 12/31/2008 6:38:01 AM
On a report can a negative number be bracketed, rather than show the -ve sign?
e.g.

-123.45
(123.45)

Seems simple but, I just can't find the format. All help much appreciated.
Re: Is there a bracket (financial) format?
Stefan Hoffmann <ste5an[ at ]ste5an.de> 12/31/2008 12:12:34 PM
hi,

8020 wrote:
[Quoted Text]
> On a report can a negative number be bracketed, rather than show the -ve sign?
> e.g.
> -123.45
> (123.45)
Try this as format string:

0,00;(0,00)

You may add a third value for empty (NULL) values, e.g

0,00;(0,00);"n/a"


mfG
--> stefan <--

Home | Search | Terms | Imprint
Newsgroups Reader