Append query using a table created from a query

Question

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_eekelen · Answer

tfmei140&nbsp;Tried your scenario and hope I understood it correctly. If not, please clarify.The attached file contains an example based on your description.

tfmei140 · Answer

Thanks&nbsp;Riny_van_Eekelen&nbsp;&nbsp;Here's my setup&nbsp;'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.&nbsp;However I don't see 'Jobs_not_invoiced' in the dialogue. There may be an easier way but I'm just starting out&nbsp;&nbsp;&nbsp;&nbsp;

riny_van_eekelen · Answer

tfmei140&nbsp;Can't tell based on a picture alone. Can you share the file?

tfmei140 · Answer

Riny_van_Eekelen&nbsp;here's the file. Hopefully it makes sense

riny_van_eekelen · Answer

tfmei140&nbsp;Thanks but there isn't much I can do with it as all queries generate errors as they can't find the source files on my system, obviously. Anyway, why does the "Jobs_not_invoiced" query show an error (as shown in your first post)? You need to fix that first. When you try to append queries, PQ doesn't 'see' the ones with errors. Should have thought about that earlier.

Forum Discussion

Append query using a table created from a query

Share

Resources