Rounding Numbers

[John]

I have a table set-up with a number data type. I initiallt setup the field
size as long integer but ran into the field automatically rounding up or
down. I just attempted to change the field size to double with 1 decimal
place. When I went to save, an error message came up stating that there are
"too many fields defined" I am unsure what this message is requesting me too
change. I am using microsoft access 2000. Thanks in advance for your help.

John

 

[Duane Hookom]

It seems to me, with that type of message you should tell us how many fields
you have defined. Do you have 20 or 200?

Typically a table with more than a couple dozen fields is not normalized. If
you really think you need over 200 fields then you will need to compact your
database to recover fields that you had renamed, deleted, or whatever.

 

[John W. Vinson]

I have a table set-up with a number data type. I initiallt setup the field
size as long integer but ran into the field automatically rounding up or
down.

Correct: an Integer is by definition a whole number, no decimals.

I just attempted to change the field size to double with 1 decimal
place. When I went to save, an error message came up stating that there are
"too many fields defined" I am unsure what this message is requesting me too
change. I am using microsoft access 2000. Thanks in advance for your help.

Back up your database before doing any of the suggestions below!!!

If you have a reasonable number of fields in your table - 30 or so - or even
an unreasonably large number - 100 maybe - try Compacting before making the
field change. That's probably a good idea anyway.

If you have more, your table design *is wrong* and needs restructuring.

You can still get around the problem by copying and pasting the table to a new
table, checking the "design mode only" checkbox to copy it with no data;
change the datatype in the new copy; run an Append query to copy the data;
drop all relationships to this table, rename the tables, restore the
relationships to the new table, delete the old table, and compact again.