Number field changing

[hmongie]

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

 

[pbaldy]

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.

 

[hmongie]

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.

 

[pbaldy]

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

 

[hmongie]

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.