Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Can you change the size of a Double or Float?

Discussion in 'Information Technology' started by RobHouston, Jul 28, 2006.

  1. RobHouston

    RobHouston
    Expand Collapse
    Guest

    I want to set a numeric field type in ACCESS, but I want it to be size 12
    with a decimal of 2. Can this be done?
     
  2. Loading...


  3. Pat Hartman\(MVP\)

    Pat Hartman\(MVP\)
    Expand Collapse
    Guest

    You need to use the Decimal data type. It supports up to 18 digits and you
    can specify a fixed decimal place.

    "RobHouston" <RobHouston@discussions.microsoft.com> wrote in message
    news:8FBA2090-792B-4AC4-A939-2D3C3F572F9F@microsoft.com...
    >I want to set a numeric field type in ACCESS, but I want it to be size 12
    > with a decimal of 2. Can this be done?
     
  4. RobHouston

    RobHouston
    Expand Collapse
    Guest

    I know about that. What I want is the number of digits to be 12. I know you
    can specify the number of decimal places.

    "Pat Hartman(MVP)" wrote:

    > You need to use the Decimal data type. It supports up to 18 digits and you
    > can specify a fixed decimal place.
    >
    > "RobHouston" <RobHouston@discussions.microsoft.com> wrote in message
    > news:8FBA2090-792B-4AC4-A939-2D3C3F572F9F@microsoft.com...
    > >I want to set a numeric field type in ACCESS, but I want it to be size 12
    > > with a decimal of 2. Can this be done?

    >
    >
    >
     
  5. James A. Fortune

    James A. Fortune
    Expand Collapse
    Guest

  6. Pat Hartman\(MVP\)

    Pat Hartman\(MVP\)
    Expand Collapse
    Guest

    If you know about that, why didn't you define the column as Decimal and set
    the Precision property to 14 and the Scale property to 2?

    I'm guessing that the answer is you didn't even bother to try. When you
    change the FieldSize to Decimal, the additional properties show up and they
    are very well documented by the notes that appear when you click into the
    field.

    "RobHouston" <RobHouston@discussions.microsoft.com> wrote in message
    news:2362E0BB-1398-4062-8EDB-BF41E523AA45@microsoft.com...
    >I know about that. What I want is the number of digits to be 12. I know
    >you
    > can specify the number of decimal places.
    >
    > "Pat Hartman(MVP)" wrote:
    >
    >> You need to use the Decimal data type. It supports up to 18 digits and
    >> you
    >> can specify a fixed decimal place.
    >>
    >> "RobHouston" <RobHouston@discussions.microsoft.com> wrote in message
    >> news:8FBA2090-792B-4AC4-A939-2D3C3F572F9F@microsoft.com...
    >> >I want to set a numeric field type in ACCESS, but I want it to be size
    >> >12
    >> > with a decimal of 2. Can this be done?

    >>
    >>
    >>
     
  7. RobHouston

    RobHouston
    Expand Collapse
    Guest

    You don't have to be such a rude and arrogant person. These communities are
    here to help people. Save your rude comments and instead be a professional.
    I tend to deal with Oracle more than ACCESS, which is why I did not know a
    simple answer to a simple question.

    "Pat Hartman(MVP)" wrote:

    > If you know about that, why didn't you define the column as Decimal and set
    > the Precision property to 14 and the Scale property to 2?
    >
    > I'm guessing that the answer is you didn't even bother to try. When you
    > change the FieldSize to Decimal, the additional properties show up and they
    > are very well documented by the notes that appear when you click into the
    > field.
    >
    > "RobHouston" <RobHouston@discussions.microsoft.com> wrote in message
    > news:2362E0BB-1398-4062-8EDB-BF41E523AA45@microsoft.com...
    > >I know about that. What I want is the number of digits to be 12. I know
    > >you
    > > can specify the number of decimal places.
    > >
    > > "Pat Hartman(MVP)" wrote:
    > >
    > >> You need to use the Decimal data type. It supports up to 18 digits and
    > >> you
    > >> can specify a fixed decimal place.
    > >>
    > >> "RobHouston" <RobHouston@discussions.microsoft.com> wrote in message
    > >> news:8FBA2090-792B-4AC4-A939-2D3C3F572F9F@microsoft.com...
    > >> >I want to set a numeric field type in ACCESS, but I want it to be size
    > >> >12
    > >> > with a decimal of 2. Can this be done?
    > >>
    > >>
    > >>

    >
    >
    >
     
  8. RobHouston

    RobHouston
    Expand Collapse
    Guest

    I did miss read the decimal for double. I think that was caused by being
    tired due to the AC breaking, but still your rude reply was not called for.

    "Pat Hartman(MVP)" wrote:

    > You need to use the Decimal data type. It supports up to 18 digits and you
    > can specify a fixed decimal place.
    >
    > "RobHouston" <RobHouston@discussions.microsoft.com> wrote in message
    > news:8FBA2090-792B-4AC4-A939-2D3C3F572F9F@microsoft.com...
    > >I want to set a numeric field type in ACCESS, but I want it to be size 12
    > > with a decimal of 2. Can this be done?

    >
    >
    >
     
  9. Pat Hartman\(MVP\)

    Pat Hartman\(MVP\)
    Expand Collapse
    Guest

    I responded in kind.

    PS, I hear that there are implementation problems with the Decimal data type
    in Access so be careful. The error I saw referenced was in regard to
    sorting. I have never used it so I have no first hand knowledge.

    "RobHouston" <RobHouston@discussions.microsoft.com> wrote in message
    news:69D0C3D7-AC90-4711-A9B5-6E5B058AA7D0@microsoft.com...
    >I did miss read the decimal for double. I think that was caused by being
    > tired due to the AC breaking, but still your rude reply was not called
    > for.
    >
    > "Pat Hartman(MVP)" wrote:
    >
    >> You need to use the Decimal data type. It supports up to 18 digits and
    >> you
    >> can specify a fixed decimal place.
    >>
    >> "RobHouston" <RobHouston@discussions.microsoft.com> wrote in message
    >> news:8FBA2090-792B-4AC4-A939-2D3C3F572F9F@microsoft.com...
    >> >I want to set a numeric field type in ACCESS, but I want it to be size
    >> >12
    >> > with a decimal of 2. Can this be done?

    >>
    >>
    >>
     

Share This Page