D DSmith Apr 29, 2004 #1 Is it possible to append to two tables with the same append query at the same time?
B Bill Taylor Apr 29, 2004 #2 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.
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.
D DSmith Apr 30, 2004 #3 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.
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.
