Number Rounding

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

Guest

Access 2000 - query build example: I am multiplying 4.38 x $20,572.00. I get
$90,105.36 and I want it to round to $901.05. How do I get this result?
Thanks!

Sam
 
Access 2000 - query build example: I am multiplying 4.38 x $20,572.00. I get
$90,105.36 and I want it to round to $901.05. How do I get this result?
Thanks!

Sam
Click to expand...

Round(4.38 * 20572 / 100, 2)

John W. Vinson[MVP]
 
Back
Top