my access is rounding up numbers and i don't want it

  • Thread starter Thread starter Katja
  • Start date Start date
K

Katja

Hello,

I have a table where a field is set to :

Datatype: number
Field Size: Long Integer
Format: Fixed
Decimal: Auto

(i also tried with decimal 2)

and when i enter values it doesn't save what comes afer
the . but rounds it up to display a full number

Example:
By default, it displays 0.00
I type 2.2
(i tries with 2.20 also)
and it saves 2.00


What is set wrong?

Please help ;-)
Thanks,
Katja
 
keep in mind that Format only affects how the data *looks*, not how it is
saved.
Long Integer is a whole number. if you want to save numbers with decimals,
change the Field Size to Single or Double.
fyi, open your table in design view, click on the Field Size line and press
F1. Access Help will automatically open to the FieldSize Property so you can
read all about it, and decide whether you need to use Single or Double.
(this is a handy trick that you can use about anywhere in Access where there
is a property "line".)

hth
 
Back
Top