Combining 2 Identical Query Columns into 1

[Guest]

I am using ODBC to connect to Quickbooks which is pulling two different types
of transactions (sales orders and invoices) from two different tables, but
they have similar column names. I have 2 queries setup to get the proper info
from each table, but I want to combine it into 1 query using one column for
each type of info. For example, Customer Name from qrysalesorders and
Customer Name from qryinvoices into one column. I would have to do this with
several columns including ship date. Is this possible?

Thanks

 

[Rick B]

I believe you are looking for a UNION query.

The help files can assist you with building one.