Re: Append Query that can append to multiple tables
you need two separate queries, although they may look very similar. When you design an append query you stipulate the table into which you want the data to append. so you can only append to one table at a time.
Here's a thought, though. If you really need the SAME data to update two different tables, then almost certainly you have a normalisation issue, and your table design could be improved.
[and i now note that this is an old thread!]
Gemma was my dog
if a poster helps you, please click the scales at the bottom left of this posting, or use the thanks button alongside.