Append query using a table created from a query
I’m trying to create an Append Query (i.e. query 2) utilising table A and table B. Table B is the result from another query (query 1) in this workbook. Query 1 utilises two tables.
Trouble is I can’t see this table in the query 2 dialogue box. How can I make table B available for the new query 2?
I’m trying to create an Append Query (i.e. query 2) utilising table A and table B. Table B is the result from another query (query 1) in this workbook. Query 1 utilises two tables. Trouble is I can’t see this table in the query 2 dialogue box. How can I make table B available for the new query 2? Read More
