Welcome to SPN

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

Sign Up Now!

Access Rounding Dollar Amount in Table

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

  1. goose1521

    goose1521
    Expand Collapse
    Guest

    I just searched and found another post that covers my issue. I have several
    large database tables that have suddenly rounded all dollar amount to 0
    decimals, even though the settings for the fields have not been changed from
    double, 2 decimals. The file is in Access 2000 Format, and I have checked in
    both Access 2002 and 2003 and the decimals are gone. The tables involved are
    over 300,000 rows of data and are for 1 year periods with daily downloads, so
    redoing is a daunting option. I may be able to restore the tables, but what
    precautions should I take to prevent this from happening again? Is there a
    glitch?
     
  2. Loading...


  3. Jerry Whittle

    Jerry Whittle
    Expand Collapse
    Guest

    If they are dollar amounts, you should have the data type set to Currency.
    Maybe the format too.
    --
    Jerry Whittle
    Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


    "goose1521" wrote:

    > I just searched and found another post that covers my issue. I have several
    > large database tables that have suddenly rounded all dollar amount to 0
    > decimals, even though the settings for the fields have not been changed from
    > double, 2 decimals. The file is in Access 2000 Format, and I have checked in
    > both Access 2002 and 2003 and the decimals are gone. The tables involved are
    > over 300,000 rows of data and are for 1 year periods with daily downloads, so
    > redoing is a daunting option. I may be able to restore the tables, but what
    > precautions should I take to prevent this from happening again? Is there a
    > glitch?
     

Share This Page