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 c...
excel
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jul 31, 2024

tfmei140 Tried your scenario and hope I understood it correctly. If not, please clarify.

The attached file contains an example based on your description.

  • tfmei140's avatar
    tfmei140
    Copper Contributor
    Jul 31, 2024

    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