Results 1 to 2 of 2
  1. #1
    slimjen is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    727

    rounding up

    I have a calculated avg field in a query that I need to round up to the nearest whole number. But when I use this:


    Code:
    AvgEE: Round([AvgOfSumOfee_count],0)
    It doesn't give me consistent results. For example 9.727272 rounds to 10, 72.6 rounds to 73 and 79.63636364 rounds to 80 but 57.63636364 rounds to 57. Why does this last one don't round to 58? And What's the best way to accomplish this?

  2. #2
    NTC is offline VIP
    Windows 10 Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    hmmm well just to experiment; one doesn't need any code for normal rounding display - you should just be able to option the field to display no decimal places. see what happens if you take out the Round and just control the display.

    I've been confused by numbers before - as what displays and what the number is - sometimes isn't easily understood; by the field name I see aggregate of aggregate and wondering maybe that is a cause.

    Definitely one can force a Round UP - but that would round 5.1 to 6 and not sure that's what you want...

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

Similar Threads

  1. Why Is It Rounding?
    By bgwool in forum Access
    Replies: 4
    Last Post: 12-10-2014, 06:24 PM
  2. Rounding
    By Rhubie in forum Queries
    Replies: 3
    Last Post: 05-30-2013, 10:55 AM
  3. rounding down
    By markcranmer in forum Queries
    Replies: 1
    Last Post: 10-11-2011, 09:43 AM
  4. Rounding
    By BLD21 in forum Reports
    Replies: 5
    Last Post: 06-20-2011, 01:06 PM
  5. Rounding off
    By Alex Motilal in forum Access
    Replies: 4
    Last Post: 12-20-2009, 12:47 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
  •  
Other Forums: Microsoft Office Forums