[AccessD] Replace negative sign with ( )

Mark Boyd MarkBoyd at McBeeAssociates.com
Fri Jan 31 11:44:00 CST 2003


I have a report that displays monetary fields with a 'Standard' format,
2 decimal places.

Currently it is showing negative numbers as -1,234.00

How can I make this display (1,234.00)?

I know this can be done if the field is formatted as Currency, but the
client doesn't want to see the dollar sign.

 

Any ideas?

 

Thanks,

Mark Boyd

Sr. Systems Analyst

McBee Associates, Inc

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030131/3329a6d3/attachment-0001.html>


More information about the AccessD mailing list