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...
 
Back
Top