Forum Discussion
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?
- Riny_van_EekelenPlatinum Contributor
tfmei140 Tried your scenario and hope I understood it correctly. If not, please clarify.
The attached file contains an example based on your description.
- tfmei140Copper Contributor
Thanks Riny_van_Eekelen
Here's my setup
'Jobs_not_invoiced' is a join of 'Jobs' (external data) and 'Sales_Invoices' (external data) and I want to append 'Sales_Invoices' to 'Jobs_not_invoiced' as I need the total across both tables.
However I don't see 'Jobs_not_invoiced' in the dialogue. There may be an easier way but I'm just starting out
- Riny_van_EekelenPlatinum Contributor
tfmei140 Can't tell based on a picture alone. Can you share the file?