Rounding

  • Thread starter Thread starter Hendrix10
  • Start date Start date
H

Hendrix10

I working with an access database that someone else created. Everytime
I enter a number it automatically rounds it to the nearest whole
number (ie 3.25 would appear as 3.00). What would I change to have the
number I entered appear?
 
Sounds as though the field's been defined as the default Long Integer.

Go into the Design view for the table and look at the Field Size for the
particular field (bottom left corner). Make sure it's Single, Double or
Decimal.
 
It could be because you are trying to enter a decimal into a Byte, Integer
or Long Integer field. Open the table in design view to check these
properties. If you wish to change the data type, be sure to back up first,
and be aware that calculations and other expressions could produce different
results than previously seen. The data type to use if you want decimals
depends on several factors, including the number of decimal places you want
to use.
 
My guess would be the field in question is a short or long integer number
data type. If so change it to a single or double precision floating point
number (change the Field Size property in table design view to do this), or
if its money to a currency data type.

The fact that its showing two zeros as the decimal places suggests its
formatted to do this, and this does tend to confirm the suspicion that it’s
the data type that's wrong.

Ken Sheridan
Stafford, England
 
Back
Top