How to round up calc to 2nd decimal place

K

KMahn

In Access, I am multiplying 2 fields; yet total will not round to 2nd decimal
place;i.e. 15.30 X 29.45 = 450.585; I would like the total to produce 450.59.
 
J

Jackie L

There were a few suggestions on this issue on 6/1/05. Look under "Rounding
Issue".
 
K

KMahn

Thanks Lynn, I found how to round up when Round function is inadequate thru
the June 1st posting called Rounding Issues.

Lynn Trapp said:
Have you tried Round([FirstField] * [SecondField], 2)?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html


KMahn said:
In Access, I am multiplying 2 fields; yet total will not round to 2nd
decimal
place;i.e. 15.30 X 29.45 = 450.585; I would like the total to produce
450.59.
Click to expand...
Click to expand...
 
Top