How do I stop Access from rounding numbers?

[Guest]

Access is automatically rounding numbers input (such as 1.5 rounding to 2).
how do I get it to keep 1.5 rather than automatically rounding?

 

[Rick B]

Change the field type. You probably have it set as an integer. An integer,
by definition, is a whole number.

 

[Guest]

Change the fields type in the table from Integer or long, to double or single
Long and integer type will round the number

 

[Guest]

Thanks! Seems to have worked.

Change the field type. You probably have it set as an integer. An integer,
by definition, is a whole number.