Query to append multiple tables

[accessaspire219]

Hey,
Is it possible to write an append query which will append each column to a different (but fixed) table?
Thanks.

 

[John Big Booty]

As far as I can see you will need to write a query for each table you wish to append to. What you could do however is run each query consecutively at the click of a button or on some other trigger that you choose.

 

[accessaspire219]

Nice!! thats a great suggestion - I hadnt thought of that
Thanks!!