Number data type in a table

[lynn]

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.

 

[JulieD]

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