Problems with Append Query

[RIngram]

I have two databases. One is created using an import macro to import the data
from a csv file. This csv file is created from a barcode scanner with part
#'s, quantities etc. The second data base is a product database which
includes the same data that the imported file with additional fields that
pertain to an individual part number. I have created an update query with a
join between the part numbers in each database. The product database hase a
field "Product ID" which is an autonumber field in this database that
increments as a new record is added. the update query is used to add the
product ID to the imported csv database. I then use an append query to add
the imported database to the end of a third database that records all
transactions.
The problem is, when each of the queries are viewed, all the fields reflect
the correct data. The append query however, when it is run, puts the part
number data in both the "Part Number" and the "Product ID" fields. Even more
confusing, if you view the append query, which will have the correct data,
highlight an individual line in the query and copy, then paste that line into
the All Transaction table, the same thing happens! The "Part #" is pasted
into both the P"Part#" and the "Product ID" fields.
Any ideas? This one is driving me crazy!

Thanks!

 

[KARL DEWEY]

Open your query in design view and look at the field row to see if you have
the Part# twice and what the Append To row says below it.
If you can not solve from there, then copy and paste your SQL to a post.