Numbers keep rounding automatically!!

[Trish]

I am doing a simple database for payroll and no matter how I try and format
the numbers, it automatically rounds up. Example, I enter in 3.5...it rounds
up to 4. All regardless of General Number, or fixed etc. Help!!

 

[Rick Brandt]

I am doing a simple database for payroll and no matter how I try and
format the numbers, it automatically rounds up. Example, I enter in
3.5...it rounds up to 4. All regardless of General Number, or fixed
etc. Help!!

You likely have picked the wrong number sub-type. If you need to support
decimals then you need to use Single or Double sub-type of Number or else
use Currency or Decimal types. The Number sub-types of Byte, Integer, and
Long Integer do not support fractional values, only whole numbers.