Append Querys?

  • Thread starter Thread starter David Miller
  • Start date Start date
D

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 ?
 
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 ?
Click to expand...

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