CURRENCY Question

Hello,

I have a report (purchase order) that shows dollar amounts for product. For
the most part, the prices are two decimal places [$x.xx] but every once in a
while, I buy smaller items that cost less than a penny each and need to enter
an amount of [$x.xxxx].

EXAMPLE right now.... if something cost $ 0.008 cents, then it shows as
unit cost: $ 0.01
qty: 1000
ext. price: $ 8.00

[so, it's doing the math right, but showing the unit cost wrong]

On my P.O. (report) it is in the format of currency with decimal places on
AUTO. If I take it off of auto and make it 4 decimal places, then ALL of the
prices show as 4 decimal places... such as $ 0.9900, which I don't want.

How can I make it so that it is normally two decimal places and only 3 or 4
when I enter it as such? Do I change it on the report? or on the underlying
table?


Thank you very much for your assistance!!!

Set the Format property to an expression like this:
$#,##0.00##;-$#,##0.00##

The zeros are forced digits, and the hashes are optional (used only when
needed.) The second part is for negative values.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"kealaz" wrote in message
...
Hello,

I have a report (purchase order) that shows dollar amounts for product.
For
the most part, the prices are two decimal places [$x.xx] but every once in
a
while, I buy smaller items that cost less than a penny each and need to
enter
an amount of [$x.xxxx].

EXAMPLE right now.... if something cost $ 0.008 cents, then it shows as
unit cost: $ 0.01
qty: 1000
ext. price: $ 8.00

[so, it's doing the math right, but showing the unit cost wrong]

On my P.O. (report) it is in the format of currency with decimal places on
AUTO. If I take it off of auto and make it 4 decimal places, then ALL of
the
prices show as 4 decimal places... such as $ 0.9900, which I don't want.

How can I make it so that it is normally two decimal places and only 3 or
4
when I enter it as such? Do I change it on the report? or on the
underlying
table?


Thank you very much for your assistance!!!

PERFECTO! Thanks Allen! I really appreciate it!