Forum Discussion

tfmei140's avatar
tfmei140
Copper Contributor
Jul 31, 2024

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?

    • tfmei140's avatar
      tfmei140
      Copper 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 

       

       

       

Resources