Can not enter a decimal

[JeffMKlein]

I have just installed access 2002 and have noticed that I can not enter a
decimal (6.5) in one of the table fields. It is rounding it up to 7. I
have the format set to general number and decimal places set to Auto. Am I
missing someting??

 

[Joan Wild]

What is the size of the field? It sounds like it's set to Integer or Long
Integer which are whole numbers only.

If you want a decimal, try Currency, Single or Double.

 

[John Vinson]

I have just installed access 2002 and have noticed that I can not enter a
decimal (6.5) in one of the table fields. It is rounding it up to 7. I
have the format set to general number and decimal places set to Auto. Am I
missing someting??

Probably. Check the datatype of the field (select the field in table
design view and look at the first row of the Properties in the lower
left of the screen).

It's probably Long Integer, the default Number datatype. An Integer
is, by definition, a whole number.

If you want decimal places, you must use Single or Double (floating
point) numbers, the newly-added Decimal type, or - if you need exactly
four, no more no fewer, decimals and no roundoff error, use a Currency
datatype instead of any sort of Number.

John W. Vinson[MVP]