Showing Negative Values in Brackets

[DanAuber]

I have a query thar returns some number fields.

On my report I want these numbers to be shown to zero negative places and with negatives formatted to be in brackets. Is there an easy way to do this ?

Thanks for any help

Dan

 

[Remou]

An example:

Format(TheNumber, "$#,##0.00;($#,##0.00)")

 

[Remou]

More detail is available at:

http://msdn.microsoft.com/library/d...us/vbenlr98/html/vafmtmultiplenumsections.asp