Decimal Places

C

Call me Ed

I have 6 tables that I am appending to an existing table. Prior to these
tables appending, I have queries built to add supplemental data and also
perform a simple minutes to hour calculation. If I look at the select query
prior to the appendage, I am able to see tenth and hundredth digits of the
hours (e.g. 30 minutes - .50 hours). After I append to the table, these
digits are truncated and it rounds to an integer. I have traced my steps and
none of the format properties are set to an integer... I have changed from
fixed to general number on the queries and the table, but no luck... Why does
it continue to truncate?
 
O

Ofer

It might sound like a silly question, but you keep mantioning the format of
the field, but what is the type of the field, if the type is integer it will
round the number.
If so, change it to double, or single.
 
J

John Vinson

On Mon, 19 Sep 2005 12:11:09 -0700, "Call me Ed" <Call me
I have 6 tables that I am appending to an existing table. Prior to these
tables appending, I have queries built to add supplemental data and also
perform a simple minutes to hour calculation. If I look at the select query
prior to the appendage, I am able to see tenth and hundredth digits of the
hours (e.g. 30 minutes - .50 hours). After I append to the table, these
digits are truncated and it rounds to an integer. I have traced my steps and
none of the format properties are set to an integer... I have changed from
fixed to general number on the queries and the table, but no luck... Why does
it continue to truncate?
Click to expand...

The Format - and even the Decimal Places property - are irrelevant.

The default Number datatype is "Long Integer". Select this field in
design view and see if that's what it says on the field properties on
the lower left of the screen, top row. If so, no amount of playing
with formats or fixed or general will help: and integer is by
definition a whole number.

Either change the type of number to Single (7 decimal places
precision), or Double (14 places), or change the datatype from Number
to Currency (four decimal places and no roundoff error).

John W. Vinson[MVP]
 
Top