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

Chely
 
J

Jeff L

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!
 
Top