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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top