Access Rounding Dollar Amount in Table

[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?

 

[Guest]

If they are dollar amounts, you should have the data type set to Currency.
Maybe the format too.