I have data that I would like to format just so:
2000 to be $2,000
-2000 to be ($2,000)
2000.01 to be $2,000.01
2000.1234 to be $2,000.1234
The 'canned' Currency format type
[that comes with MS-Access 2002(10.3409.36 01) SP-1]
*rounds* the fractions of a cent to the nearest cent.
I need to preserve the cents and fractions of cents,
only when they respectively exist.
My attempt at a custom format
$#,###.####;($# ,###.####)
deals with the mils, but fails to
suppress the decimal point thusly
2000 becomes $2,000. not $2,000
-2000 becomes ($2,000.) not ($2,000)
I would like to suppress the decimal point
when the cents are zero.
1) Anybody know the solution to my specific problem?
2) Where is the *definitive* resource to learn about the
Format property in MS-Access reports? The {F1} help
file only brings up some abridged documentation, not
explaining all the intricacy.