Saving Decimal Values in Tables - How?

[Guest]

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.

 

[Jamie Collins]

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

Change the Field size to single or double.

From the title of the post I'd guess they want 'Decimal'. Data that is

genuinely floating point in nature is very rare.

Jamie.

--