Entering data decimals

[Guest]

When I enter data into my table, in a numeric field it rounds to a whole
number. I have decimals set to auto or 2, it gives the same. If I enter 42.75
it enters 43, 42.5 returns 42.

 

[Mike Labosh]

When I enter data into my table, in a numeric field it rounds to a whole

number. I have decimals set to auto or 2, it gives the same. If I enter
42.75
it enters 43, 42.5 returns 42.

Check the Field Size property of the column in the table design view. In
Access, when you make a Number type field, by default, it is set to Long
Integer. Try changing the Field Size to Single, Double or Decimal.
--
Peace & happy computing,

Mike Labosh, MCSD

"It's 4:30 am. Do you know where your stack pointer is?"