Saving Decimal Values in Tables - How?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

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

Change the Field size to single or double.
 
fredg said:
Your Field Size is Long nteger.
By definition, an Integer is a whole number; No decimals.

Change the Field size to single or double.
Click to expand...
From the title of the post I'd guess they want 'Decimal'. Data that is
Click to expand...
genuinely floating point in nature is very rare.

Jamie.

--
 
Back
Top