Displaying Numbers

[lmgraham0629]

Hi,
This may sound silly, but I have several fields that have numbers that need
to be expressed to the 10th (ex. 99.9) and for some reason Access keeps
rounding them up or down...It'll still display the 10th place but only as a
0?

 

[John W. Vinson]

Hi,
This may sound silly, but I have several fields that have numbers that need
to be expressed to the 10th (ex. 99.9) and for some reason Access keeps
rounding them up or down...It'll still display the 10th place but only as a
0?

Open the table in design view and look at this field's properties (in the
lower left of the screen). Odds on, you have used the default Number datatype
Long Integer - and an integer is by definition a whole number.

If you want decimal places you must use a datatype which supports them; either
Number... Single or Number... Double (floating point numbers which give about
7 or 14 decimals precision respectively); Decimal, which lets you specify the
precision; or use a Currency datatype instead of Number, which will give you
exactly four decimals precision and no roundoff error.

 

[fredg]

Hi,
This may sound silly, but I have several fields that have numbers that need
to be expressed to the 10th (ex. 99.9) and for some reason Access keeps
rounding them up or down...It'll still display the 10th place but only as a
0?

Most likely explanation is that the field's datatype is Number, Field
Size Integer.
By definition, an Integer cannot have a decimal value (it's a whole
number).
Either change the Field Size to Double, or change the Field's datatype
to Currency.