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
|
|||
|
|||
Number data type in a table
I have noticed that when I set the data type to Number,
the data is automatically rounding to the nearest whole number. My data consists of numbers like 1.2, 1.5, 1.8, 2.2.... etc... This is rounding to just show 1,1,2,2.... does anyone know why this is ? Its set to Long Integer, and I tried to change the formatting to General Number, but it still rounds the data. Happens using either Access 2000 or 2002. |
#2
|
|||
|
|||
Number data type in a table
Hi Lynn
its to do with the "long integer" more than the "number" an integer (and therefore a long integer) store only whole numbers for decimals try double by the way, its not just displaying it wrong, entering a decimal into an integer field results in the number being truncated and AFAIK it is "non-recoverable" Cheers JulieD "lynn" wrote in message ... I have noticed that when I set the data type to Number, the data is automatically rounding to the nearest whole number. My data consists of numbers like 1.2, 1.5, 1.8, 2.2.... etc... This is rounding to just show 1,1,2,2.... does anyone know why this is ? Its set to Long Integer, and I tried to change the formatting to General Number, but it still rounds the data. Happens using either Access 2000 or 2002. |
Thread Tools | |
Display Modes | |
|
|