 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / January 2005Number Rounding
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 Round(4.38 * 20572 / 100, 2) John W. Vinson[MVP] Thank you! Worked great!!! > >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? [quoted text clipped - 5 lines] > > John W. Vinson[MVP] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.