A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Number data type in a table



 
 
Thread Tools Display Modes
  #1  
Old June 8th, 2004, 08:03 PM
lynn
external usenet poster
 
Posts: n/a
Default 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  
Old June 8th, 2004, 08:20 PM
JulieD
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:51 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.