How do I stop Access from rounding Numeric Fields?

[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,

 

[Dirk Goldgar]

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.

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.

 

[Larry Linson]

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.

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