numbers round (2003)

Topic

New Reply

I have a db with a field set as a general number. I am trying to enter 2.05, but it displays 2. I have tried using fixed digit set to 2, but that doesn’t work either. What am I doing wrong? I need this number field to show the number as it is entered.

Reply | Quote

Replies

If the size of the field is Byte, Integer or Long Integer, it will only store whole numbers.
If you want to be able to store fields with a fractional part, set the field size to Single or Double. Or use a Currency field instead of a Number field.

Reply | Quote

Bingo. Jeesh. Thank you!! I read the help screen in Access, but I guess I misinterpreted what it said. Thank you.

Reply | Quote

It sound like the field is set to be an Integer or Long Integer. Integers are whole numbers.
In the Design of the table, change it to a single or double, which refers to single or double precision decimals.

Reply | Quote