Appending two tables

  • Thread starter Thread starter DSmith
  • Start date Start date
No. There is only one destination table allowed, unfortunatilly. The easiest
way I have found is to copy the query and change the destination table.
 
Thanks, I was afraid of that. Unfortunately, when I add the new records, the
records will change in the query and they will no longer be there to try to
add the other information to another table. I guess this will take more
thought.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Query Issue 0
Access 2010 append query to SQL is very slow 0
Append to two different tables 23
Schedule Auto run Query on append table 0
Choose append field based on criteria 4
linked worksheet connection error 5
How do I get Access to append the exact amount with decimals? 2
Access 2007 - append query only appending 0 rows??? 0

Back
Top