Stopping number rounding up

[Firemansam]

G'day All,

I have a table that allows for data to be automatically imported into it or manually entered. When data is automatically entered into the table the number field shows the number as a decimal, but when I manually entered data into the column it rounds it up or down to the nearest whole number.
I have checked the the decimal place setting on the particular item and it is set to allow for 2 decimal places the format is fixed and the number itself is Long integer

Any help would be a appreciated.

 

[boblarson]

Long Integer is just that - an integer doesn't allow for decimal places. So, if you want the decimals, you should change your datatype to Single, Double, or Decimal.