This might be simple but I just can't figure it out.

I have a table that has a number field. Everytime I enter the number 1.50, it changes to 2. I would like to keep the 1.50. Somehow, I can't get this right. Is there a setting that I have to change? Would I need to make setting changes on the form portion also?

thanx for any help

If the field size is Integer or Long Integer (at the table level), you'd see that kind of behavior. Change it to a type that holds a decimal; the appropriate type would depend on your application.

I have Access 2000.

The field is used to retain milage. When I enter 1.5, it changes to 2. When I enter 1.3, it changes to 1. It appears to be rounding the numbers off to the whole number.

My settings for this number field are: Field Size is Long Integer, Format is General Number (Supposely it is suppose to retain what ever number is entered), and Decimal place is Auto.

I just want the numbers to stay the way they are. If I enter 1.51 then it should stay 1.51.

If the field size is Integer or Long Integer (at the table level), you'd see that kind of behavior. Change it to a type that holds a decimal; the appropriate type would depend on your application. Neither of the Integer types will hold a decimal (hence the name). Like I said, change it to a type that will hold one (decimal, single, double, currency).

Hey thanks for posting. I finally figure it out this morning. I made adjustments to the scale. Somehow the default on mine is 0.

Thanks.