G
Geo
In an ACCESS 2002 XP form, i use a combo box to select a value from a query
and add it to a table.
The field in the query is like
Sum(lenght)
with the Format: Standard
Decimal places: 3
The field in the table has also 3 decimals (number with field size DOUBLE,
format STANDARD and Decimal Places 3).
The PROBLEM is that in the combo box I don't see anymore the number with 3
decimals. It is rounded at 2 decimals, so the number added in the table will
not be correct.If I set the format Standard and Decimal Places 3 for the
combo, that is just adding a "0" at the end of the ROUNDED number.
Can somebody,please, help me!
I need this number with 3 decimals to be correct because repesents a maximum
limit for a quantity.
and add it to a table.
The field in the query is like
Sum(lenght)
with the Format: Standard
Decimal places: 3
The field in the table has also 3 decimals (number with field size DOUBLE,
format STANDARD and Decimal Places 3).
The PROBLEM is that in the combo box I don't see anymore the number with 3
decimals. It is rounded at 2 decimals, so the number added in the table will
not be correct.If I set the format Standard and Decimal Places 3 for the
combo, that is just adding a "0" at the end of the ROUNDED number.
Can somebody,please, help me!
I need this number with 3 decimals to be correct because repesents a maximum
limit for a quantity.