Decimal place update not allowed?! (Access 2007)

[branston]

I am trying to add decimal places to a field (set as Number, long integer, fixed, 2decimal places). Its showing as 32.00, but if i try to change it to 32.59 it returns to 32.00 as soon as i click outside the box.

any ideas?

Thankyou!

 

[branston]

dont worry - I needed to set it as a decimal rather than an integer... out of practice!

 

[Galaxiom]

Decimal datatype doesn't actually mean what you might assume.
Decimal is a precision scaled integer used in division where the result must be precise to (generally speaking) more then three decimal places.

Most real numbers can be stored in the Single data type.