How to change whole numbers to decimals

  • Thread starter Thread starter Chely
  • Start date Start date
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
 
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)
 
Back
Top