Append Querys?

[David Miller]

I am using a Pocket PC to collect data on the manufacturing
floor, importing that data into an Access Data Table. I
clear the information out of my Pocket PV on a daily basis
and want to accumalate the data in the table that I have
set up.

I have setup 2 tables. The first table I use to upload
from my Pocket PC and the second one I want to store as
history.

I have set up an "APPEND" query with the intent to save the
new information in an archieve (history) table. When I run
the query to transfer the information into the history
table, it also adds the information to my transfer table.
Any suggestions ?

 

[John Vinson]

I have set up an "APPEND" query with the intent to save the
new information in an archieve (history) table. When I run
the query to transfer the information into the history
table, it also adds the information to my transfer table.
Any suggestions ?

Post the SQL of the query. Something's odd - it should certainly not
be appending to two tables with one operation.