How to change whole numbers to decimals

C

Chely

Hi everybody:
I have a field in a linked table that only accepts whole numbers and
sometimes i need to enter decimals, but if i enter decimals when i save
it changed to a whole number. How i can fix this problem?, and also
this is a linked table, How i can modify this field? Thanks
 
J

jahoobob via AccessMonster.com

Copy the table for backup, just in case. Open the table in design view.
Select the field you are changing. Look in the field properties (bottom)
portion of the design view and note that the Format is probably Short Integer
or Long Integer. Change that to Single or Double.
If this is a linking field, you will have to do the same for the linked table
(s)
 
Top