Results 1 to 2 of 2

Rounding in Access 2010

  1. #1
    rgreenbank is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2013

    Rounding in Access 2010

    I'm having trouble with rounding in Access 2010. In a query I am using the following Round((([net_weight]/100)*.35),0). Even when I add .0001 before rounding Access is still rounding .76 down in some instances. I thought even with bankers rounding anything over .51 would be rounded up. Could someone help me with a fix?


  2. #2
    RuralGuy's Avatar
    RuralGuy is online now Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    8300' in the Colorado Rocky Mountains
    Here's a good description of how the MS Access Round() function works:
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro - acXP, ac07, ac10, ac13
    If your issue is resolved...go ahead and use the Thread Tools at the top of the thread and mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 04-15-2015, 01:48 PM
  2. Replies: 9
    Last Post: 05-07-2013, 08:37 PM
  3. Replies: 4
    Last Post: 09-19-2012, 02:07 AM
  4. Replies: 0
    Last Post: 07-31-2012, 12:25 PM
  5. Replies: 1
    Last Post: 01-05-2012, 01:34 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Tech Forums: Microsoft Office Forums