Rounding Numbers

[Elliott]

How do you stop Access from rounding numbers?
I have changed the decimal place settings but my numbers
keep getting rounded eg. 1.4 gets changed to 1.0

 

[Andrew Smith]

Make sure that the Field Size is "Single" or "Double", and not "Integer" or
"Long Integer" (the default is long integer). (Look in table design).

 

[Bob]

Define the field as a Double