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
|
|||
|
|||
# is rounding. Do not want
I need help. I have a field set as number. long integer
size, standard format with 2 decimals. the number keeps rounding if i enter in a decimal number in the forms and thru datasheet view of table. can someone help me? thanks! |
#2
|
|||
|
|||
# is rounding. Do not want
i forgot to add this. even using the decimal field size
does not work. -----Original Message----- I need help. I have a field set as number. long integer size, standard format with 2 decimals. the number keeps rounding if i enter in a decimal number in the forms and thru datasheet view of table. can someone help me? thanks! . |
#3
|
|||
|
|||
# is rounding. Do not want
The Integer types (including Long) can store only whole numbers.
In table design view, change it to a Number of size Double instead. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "cedia" wrote in message ... I need help. I have a field set as number. long integer size, standard format with 2 decimals. the number keeps rounding if i enter in a decimal number in the forms and thru datasheet view of table. can someone help me? thanks! |
#4
|
|||
|
|||
# is rounding. Do not want
You need to change the Data Type (Field Size) from Integer to Single or
Double, also change the Format and Input Mask if you have them. Since you have already created the form, the setting changes won't be carried over automatically. You'll need to go to the textbox on the form and set Format and Input mask there as well. -- Wayne Morgan MS Access MVP "cedia" wrote in message ... I need help. I have a field set as number. long integer size, standard format with 2 decimals. the number keeps rounding if i enter in a decimal number in the forms and thru datasheet view of table. can someone help me? thanks! |
#5
|
|||
|
|||
# is rounding. Do not want
Awesome!!
problem solved.Thanks a million everyone! -----Original Message----- You need to change the Data Type (Field Size) from Integer to Single or Double, also change the Format and Input Mask if you have them. Since you have already created the form, the setting changes won't be carried over automatically. You'll need to go to the textbox on the form and set Format and Input mask there as well. -- Wayne Morgan MS Access MVP "cedia" wrote in message ... I need help. I have a field set as number. long integer size, standard format with 2 decimals. the number keeps rounding if i enter in a decimal number in the forms and thru datasheet view of table. can someone help me? thanks! . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Rounding Error | Peo Sjoblom | Worksheet Functions | 3 | April 19th, 2004 01:59 PM |
No Rounding - need full decimal value | JE McGimpsey | Worksheet Functions | 2 | March 10th, 2004 10:55 PM |
rounding | Carla | Worksheet Functions | 1 | February 4th, 2004 03:08 PM |
Excel function - Rounding currency | Marrick | Worksheet Functions | 1 | January 15th, 2004 10:51 AM |
rounding in excel 2000 | Jennifer | Worksheet Functions | 2 | December 12th, 2003 09:53 PM |