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

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

Brian


"BardsSweetie" <(E-Mail Removed)> wrote in message
news:9C450970-8A37-4E55-BCC0-(E-Mail Removed)...
> 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
>
>
>