How do I stop Access from rounding numbers?

G

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?
 
R

Rick B

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

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stopping Fields from Rounding in Tables 2
How do you turn off automatic rounding in a query IIf statement? 2
Import Excel 2007 into Access 2007 3
How do I stop Access from rounding Numeric Fields? 2
Numbers are automatically rounding up in Tables, Forms, etc. 3
Stop Rounding in Forms 2
Rounding 3
How can I change text box from number to text? 1

Top