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?

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?