Calculation Question ... I just can't get it right

[Guest]

Hi ... again ...

This is driving me nuts.

Qty Received - 5
Price Per UoM - $10.98
Price Each - $2.20 (should be $2.19)

1. How can I stop Access from rounding UP? I don't know what I need to
change.

2. Next I have an adjustment field. This is the difference between Price
Per UoM ($10.98) and Qty Received MULTIPLIED BY Price Each ($2.19 X 5=$10.95).

3. If I can stop Access from rounding up will #2 above work the right way?

I've tried using the CCur and also just using the = sign and nothing is
working the way it should. I've got the Format set to CURRENCY and the
Decimal Places set to 2.

Any help is very much appreciated.

Kathleen

 

[Brian Bastl]

You received a reply from Wayne Morgan in the m.p.a.forms group to which you
originally posted.

Brian