Forum Discussion
Append query using a table created from a query
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
tfmei140 Can't tell based on a picture alone. Can you share the file?
Riny_van_Eekelen here's the file. Hopefully it makes sense
tfmei140 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.
