Stopping Fields from Rounding in Tables

  • Thread starter Thread starter tsquared1518
  • Start date Start date
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?
 
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.
 
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

Rounding up! 2
Preventing entries based on a field 2
Bankers Rounding 1
Stop Rounding in Forms 2
How do I stop Access from rounding Numeric Fields? 2
Rounding Problem 1
Access 2007: % fields rounding to nearest integer 3
Preventing rounding numbers to nearest dollar 2

Back
Top