Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jul 2002
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Rounding Numbers (Access 2000)

    Is there an expression I can use to round numbers to the nearest tenth in a query?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Rounding Numbers (Access 2000)

    Use =Round(Something,1) where Something can be a field name or an expression (if the field name contains spaces, enclose it in square brackets).

  3. #3
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rounding Numbers (Access 2000)

    I get an error message "Undefined function 'Round' in expression." when I run the query. I am dividing Field A /Field B = Field C. Field B has 0 decimals defined, while Field A and Field C have three decimals defined.

  4. #4
    Star Lounger
    Join Date
    Aug 2001
    Location
    Seattle, Washington, USA
    Posts
    50
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rounding Numbers (Access 2000)

    Here is a KB article that might help. This is another one to check out.

    These are for Access 2000, according to the Microsoft Knowledge Base.

    HTH,

    Tom

  5. #5
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rounding Numbers (Access 2000)

    Apparently this solves my problem. Many thanks.

Posting Permissions

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