How to round up calc to 2nd decimal place

[Guest]

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.

 

[Lynn Trapp]

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

 

[Guest]

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

 

[Guest]

thanks Jackie, I am new to this and your suggestion helped enormously.

 

[Guest]

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

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

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.