How do I stop Access from rounding Numeric Fields?

  • Thread starter Thread starter jgiene
  • Start date Start date
J

jgiene

I have created a table in Access, and I have serval Numeric Fields but when I
type in "39.40" it displays as "39.00." I need the numbers after the decimal
to appear. Does anyone have any idea how I can get Access 2007 to stop
rounding my numeric values.

Thanks,
 
jgiene said:
I have created a table in Access, and I have serval Numeric Fields but when
I
type in "39.40" it displays as "39.00." I need the numbers after the
decimal
to appear. Does anyone have any idea how I can get Access 2007 to stop
rounding my numeric values.
Click to expand...


In the table design, you have probably defined the fields with the field
size as Long Integer (or Integer or Byte), rather than as Single, Double, or
Currency. the Long Integer, Integer, and Byte data types are whole-number
types that can't store decimal places no matter how you set the format. For
floating-point numbers, choose Single or Double, depending on the precision
required; for money values choose Currency.
 
jgiene said:
I have created a table in Access, and I have serval Numeric Fields but when I
type in "39.40" it displays as "39.00." I need the numbers after the decimal
to appear. Does anyone have any idea how I can get Access 2007 to stop
rounding my numeric values.
Click to expand...

Most probably, you need to stop defining them as Integer or Long Integer,
neither of which has provision for decimal places. IIRC, the default
definition when you choose "Numeric" is "Long Integer". Look in the
information area below the fields in Table design view.

If that is not the problem, then you need to examine the Formatting you are
using.

Larry Linson
Microsoft Office Access MVP
 
Back
Top