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

Chely
 
If the number field in the linked table is set to Long Integer in the
Field Size, then you cannot save decimal values to that field. You
would need to change the Long Integer to something like Double for
decimals to be saved. You cannot change the properties of a linked
table. You would need to where the table is being linked from and then
change the table at that location.

Hope that helps!
 
Back
Top