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
    Posts
    1

    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?

    Thanks,
    rgreenbank

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    10,937
    Here's a good description of how the MS Access Round() function works: http://www.techonthenet.com/access/f...eric/round.php
    (RG for short) aka Allan Bunch 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: 9
    Last Post: 05-07-2013, 07:37 PM
  2. Replies: 3
    Last Post: 12-04-2012, 01:00 PM
  3. Replies: 4
    Last Post: 09-19-2012, 01:07 AM
  4. Replies: 0
    Last Post: 07-31-2012, 11:25 AM
  5. Replies: 1
    Last Post: 01-05-2012, 12: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