If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to change whole numbers to decimals
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 |
#2
|
|||
|
|||
How to change whole numbers to decimals
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) Chely wrote: 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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200608/1 |
Thread Tools | |
Display Modes | |
|
|