Stopping Fields from Rounding in Tables

T

tsquared1518

I am trying to enter values like 1.814 into fields, but it keeps rounding up
to 2. How do I get it to stop rounding?
 
F

fredg

I am trying to enter values like 1.814 into fields, but it keeps rounding up
to 2. How do I get it to stop rounding?
Click to expand...

Most likely the field's datatype is Number, Field Size Integer.
By definition, an Integer is a whole number, no decimal values
allowed.
Either change the field's Datatype to Currency or leave it as Number
but change the Field Size to Single or Double, whichever is most
suitable for the purpose.
 
T

tsquared1518

Double worked...Thank you!

fredg said:
Most likely the field's datatype is Number, Field Size Integer.
By definition, an Integer is a whole number, no decimal values
allowed.
Either change the field's Datatype to Currency or leave it as Number
but change the Field Size to Single or Double, whichever is most
suitable for the purpose.
Click to expand...
 

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

How do I stop Access from rounding Numeric Fields? 2
How do you turn off automatic rounding in a query IIf statement? 2
Rounding 3
Access 2007: % fields rounding to nearest integer 3
Bankers Rounding 1
stop automatic rounding 3
How do I stop Access from rounding numbers? 3
Rounding Numbers 2

Top