Why does access round up to whole numbers.

  • Thread starter Thread starter Alan
  • Start date Start date
A

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
 
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?
Click to expand...

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
 
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.
 
: 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.
 
Back
Top