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)
 
You must log in or register to reply here.

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

Similar Threads

How to change whole numbers to decimals 1
Decimal places in forms 2
Using Numbers and decimals 7
Form Rounds up Decimal numbers, WHY? 7
formula for decimal point 4
Access stripping decimal places in query 1
How do I stop rounding of my calculation results. 6
Convert Decimal fractions to binary and vice versa 1

Back
Top