Entering Decimals in a Table

[Ian Potter]

I want to be able to enter 17.5 in a table field, but when I enter to go to
next record it rounds up to 18.
The field settings are: -
Data type is Number
Field Size is Long Inter
Format is General Number
and I have tried both
Decimal Places set to 2 and Auto
All to no avail
Please can you help?

 

[MelVin72]

You need to set the field to Double, not Long Integer.

 

[Tom Ellison]

Dear Ian:

The clue here is the Field Size. I believe what it says is probably "Long
Integer".

These cannot store fractions. They store whole numbers only. If you
require to store values with significance to the right of the decimal point,
you need to study the numeric data types to find what is appropriate. Hint:
if the value is not a measurement, like feet, pounds, or seconds, then
probably avoid the floating point types. Look at currency/money for one
thing. A value doesn't have to be money to be able to use these.

I'm confused by the ability to set decimal places on integer data types.
I've seen that the option is there. Anybody want to clue me in?

Tom Ellison

 

[John Spencer]

Long integer hold only integers (whole numbers, no fractional parts).
Change the field size to double (that hold decimals) or change th field type
to currency (which hold numbers with up to four decimal places).

 

[Ian Potter]

Thanks All
Changing to Double from integer Worked Great