Apending from a linked table

[Serene]

I have a table in Access linked to an Excel spread
sheet. When I view the data in this table, it appears as
it should. I am appending two columns from this table to
another table in the same database. One of the columns
appends without any issue. The other one which is
formated as a percentage field rounds up to 100% or down
to 0% depending which side of 50% it is on. The fields
that the data is to reside in both tables are formatted
as percentage as is the field in the append quiery.

Can anyone advise me on how to get around this rounding
problem?

 

[John Nurick]

Hi Serene,

In Excel, Access and many other programs, percentages are stored as
numbers between 0 (0%) and 1 (100%). So the field in the second table
must be a suitable data type, e.g. Single or Double (rather than the
usual Long or Integer, which can only store whole numbers).

 

[Serene]

Thanks John

-----Original Message-----
Hi Serene,

In Excel, Access and many other programs, percentages are stored as
numbers between 0 (0%) and 1 (100%). So the field in the second table
must be a suitable data type, e.g. Single or Double (rather than the
usual Long or Integer, which can only store whole numbers).

I have a table in Access linked to an Excel spread
sheet. When I view the data in this table, it appears as
it should. I am appending two columns from this table to
another table in the same database. One of the columns
appends without any issue. The other one which is
formated as a percentage field rounds up to 100% or down
to 0% depending which side of 50% it is on. The fields
that the data is to reside in both tables are formatted
as percentage as is the field in the append quiery.

Can anyone advise me on how to get around this rounding
problem?

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.