Hello,
I recently tried to create a query that would take data from a linked table and append it to a structure copy of the initial table. The query pulls the data, and it appears on the query tab, but does not archive the data into the table that the query is appending into. Has anyone encountered this problem and if so what steps can be taken to create a query that effectively updates my archive table?