 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / March 2007Round
Is there any simple way to round? Function Round or Int Or Format Round(2.44) will return 2 Round(2.55) will return 3 Round(2.55,1) will return 2.6 Round(2.54,1) will return 2.5 Int(2.44) will return 2 Int(2.55) will return 2 Format(2.55,"#") will return 3 Format(2.44,"#") will return 2  SignatureGood Luck BS"D > Is there any simple way to round? > Is there any simple way to round? Many. Are you particular about what form of rounding you want? SignatureJoseph Meehan Dia 's Muire duit It's for a dollar amount and I just want to round to the whole dollar. Is there a simple expression I can use? > > Is there any simple way to round? > > Many. Are you particular about what form of rounding you want? > It's for a dollar amount and I just want to round to the whole > dollar. Is there a simple expression I can use? OK how about this question $1.00 = 1 $1.01 = ?? $1 or $2 $1.49 = ?? $1 or $2 $1.50 = ?? $1 or $2 $1.51 = ?? $1 or $2 $1.99 = ?? $1 or $2 Those answers are all correct depending on the rounding you want. >>> Is there any simple way to round? >> [quoted text clipped - 4 lines] >> >> Dia 's Muire duit SignatureJoseph Meehan Dia 's Muire duit Hi some time ago I had little bit different problem also asociated to rounding and this page I found very interesting : http://ewbi.blogs.com/develops/2003/11/vba_round_yet_a.html Good luck as you might need it ! It should be something like: $1.50 = $1 $1.51= $2 > > It's for a dollar amount and I just want to round to the whole > > dollar. Is there a simple expression I can use? [quoted text clipped - 23 lines] > >> > >> Dia 's Muire duit > It should be something like: > $1.50 = $1 > $1.51= $2 That is called banker's rounding http://en.wikipedia.org/wiki/Rounding Additional information on Rounding in Access can be found at: http://ewbi.blogs.com/develops/2003/11/vba_round_yet_a.html >>> It's for a dollar amount and I just want to round to the whole >>> dollar. Is there a simple expression I can use? [quoted text clipped - 28 lines] >> >> Dia 's Muire duit SignatureJoseph Meehan Dia 's Muire duit <quibble> That's not Banker's Rounding. Banker's Rounding always rounds .5 to the closest even value. In other words, it would round both $1.50 and $2.50 to $2. </quibble> SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) >> It should be something like: >> $1.50 = $1 [quoted text clipped - 40 lines] >>> >>> Dia 's Muire duit > <quibble> > That's not Banker's Rounding. Banker's Rounding always rounds .5 to > the closest even value. In other words, it would round both $1.50 and > $2.50 to $2. > </quibble> Now that I think about it, you are right. I have been out of the business too long. (Thank God) >>> It should be something like: >>> $1.50 = $1 [quoted text clipped - 45 lines] >> >> Dia 's Muire duit SignatureJoseph Meehan Dia 's Muire duit |
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.