Saving Decimal Values in Tables - How?

[HarryJ]

I have a table where I am trying to save decimal values (i.e. 2.4, 3.5, 17.9,
etc.). The field is setup as follows:
Field Size: Long Integer
Format: Fixed
Decimal Places: 1
Input Mask: (Blank)
Caption: Duration(Hrs)

The problem is that when I input 4.5, the table shows and saves 4.0

What am I doning wrong?

Thanks.

 

[fredg]

I have a table where I am trying to save decimal values (i.e. 2.4, 3.5, 17.9,
etc.). The field is setup as follows:
Field Size: Long Integer
Format: Fixed
Decimal Places: 1
Input Mask: (Blank)
Caption: Duration(Hrs)

The problem is that when I input 4.5, the table shows and saves 4.0

What am I doning wrong?

Thanks.

Your Field Size is Long nteger.
By definition, an Integer is a whole number; No decimals.

Change the Field size to single or double.