Results 1 to 5 of 5

Thread: Round up?

  1. #1
    Join Date
    Aug 2003
    Posts
    2

    Round up?

    I am trying to roundup a calculation using the expression builder but can't find a command to handle this.

    Fairly novice user using Expression Builder as opposed to SQL. Any help would be appreciated.

    Have tried MROUND, and ROUND which are not recognized

  2. #2
    Join Date
    Aug 2003
    Location
    In a galaxy far, far away...
    Posts
    28
    Try Int() function

  3. #3
    Join Date
    Aug 2003
    Posts
    2

    Need to round up

    Corruptor,

    Thanks for reply. Looks like INT() rounds down, I need to round up.

    Any other ideas?

    Thanks again

  4. #4
    Join Date
    Aug 2003
    Location
    In a galaxy far, far away...
    Posts
    28
    Since I don't know Access deeply I would say no, but...

    It takes some time to solve it but it should work:

    Create your own function something like this in Basic module:

    Function RoundUp(ToRound as Single) as Integer
    RoundUp=ToRound
    end Function


    This will work for sure, 'cause VBA will do the correct rounding for you.

    Once you have defined this function you can use it anywhere you want.


    Hope this helps.

  5. #5
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    SELECT ROUND(12.55,1);

    result 12.6

    SELECT ROUND(12.55,0);

    result 13

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •