Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Sep 2005
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Rounding to nearest whole number (2002)

    how can i round a number up or down to the nearest round number, so if i had 3.3 it would be 3 or if it was 3.7 it would be 4 and so on?

  2. #2
    4 Star Lounger
    Join Date
    Sep 2004
    Location
    Sacramento, California, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rounding to nearest whole number (2002)

    In table design if you make the data type of the field number and the format integer or long integer when you enter the data it will automatically round.

    Carla

  3. #3
    2 Star Lounger
    Join Date
    Mar 2005
    Location
    Anderson, Indiana, USA
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rounding to nearest whole number (2002)

    I am assuming you are wanting to round in a query, if so then.

    Round ([yourfield], 0)

    Replace yourfield with the field you are wanting to round and the 0 is the precision of decimal places.

Posting Permissions

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