Re: conditionally round decimal numbers from 8 places to 6 places

Discussion in 'Microsoft Access Queries' started by pietlinden@hotmail.com, Jan 16, 2007.

  1. Guest

    Melanie O wrote:
    > I have a table with numbers ranging from 0 to 777000.05. The data type is
    > decimal, precision 17, scale 2.
    >
    > Is there a way to find the numbers that have more than 6 total digits (to
    > the right and left of the decimal) and round off the remainder? So 777000.05
    > becomes 777000, and 6.25 stays 6.25.
    >
    > Thanks,
    > Melanie


    use the Round function. You can specify how many significant figures
    you want to keep. It may be under VB help.
     
    , Jan 16, 2007
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    Round double to 2 decimal places?

    Guest, Oct 21, 2004, in forum: Microsoft Access Queries
    Replies:
    1
    Views:
    539
    [MVP] S.Clark
    Oct 22, 2004
  2. Guest

    Round double to two decimal places

    Guest, Oct 21, 2004, in forum: Microsoft Access Queries
    Replies:
    1
    Views:
    203
    [MVP] S.Clark
    Oct 22, 2004
  3. Guest

    NUMBERS TO TWO DECIMAL PLACES

    Guest, Apr 11, 2006, in forum: Microsoft Access Queries
    Replies:
    1
    Views:
    122
    BruceM
    Apr 11, 2006
  4. John Spencer

    Re: conditionally round decimal numbers from 8 places to 6 places

    John Spencer, Jan 16, 2007, in forum: Microsoft Access Queries
    Replies:
    0
    Views:
    248
    John Spencer
    Jan 16, 2007
  5. John Nurick

    Re: conditionally round decimal numbers from 8 places to 6 places

    John Nurick, Jan 16, 2007, in forum: Microsoft Access Queries
    Replies:
    0
    Views:
    244
    John Nurick
    Jan 16, 2007
Loading...

Share This Page