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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
You received a reply from Wayne Morgan in the m.p.a.forms group to which you
originally posted.

Brian
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculation Problems ... Again... 3
Table/Form Division Question 4
How to stop Excel from rounding a number? 3
Excel Excel 2007 won't stop rounding down my formula results! 5
Table/Form Division Question **BUMP** 1
HELP!! Problem with the number of decimals in calculations 1
I get #Error in Access Report. from Expr =[Price]*[Quantity] Why? 1
Insert Calculated Field (wrong Qty*Price = wrong Amount) 8

Back
Top