Why does access round up to whole numbers.

[Alan]

I have an unlinked table in access in which there is a
field that should hold numerical values to 1 decimal
place. The field format is an integer fixed to 2 decimal
places. However when I type in 11.5 a value of 12.00
appears in the table. Whats going on!

thanks in advance for your help

 

[Kevin]

The field format is an integer fixed to 2 decimal

places. However when I type in 11.5 a value of 12.00
appears in the table. Whats going on?

An integer is by definition a whole number. Define as
numeric type Single (4 bytes) or Double (8 bytes) to store
decimal numbers.

HTH
Kevin

 

[Randy Harris]

An integer field can only hold integer values. Regardless of how you format
the display, an integer field will not store anything between 11 and 12.

 

[Peggy W. Dalton]

: I have an unlinked table in access in which there is a field
that should hold numerical values to 1 decimal place

Kevin and Randy replied: very clever, guys! Yes, I knew integers were
whole numbers, but it did not 'click' in my brain. I am so happy because I
was having a problem like Alan's, and it was becoming very frustrating!

Thank you, thank you, thank you.

 

[Alan]

Thanks for your help
Feeling a bit stupid now!