Entering data decimals

  • Thread starter Jonedangerousli
  • Start date
J

Jonedangerousli

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.
 
M

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.
Click to expand...

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?"
 
Top