Concatenating two sets of records

[Bob Howard]

I have two "sub"-queries that each yield the correct set of data from each
of two sets of source tables. These tables have some degree of commonality
(but are not "related").

The field (column) names in each of these two queries are identical to one
another. Where one either of the queries does not produce any data for a
particular field that only has meaning in the other query, I simply define a
field with the appropriate name (i.e., the same name as in other other
query)and assign it a value of Null.

What I now want to do is bring BOTH result sets together (concatenate them,
one after the other), sort the result, and produce a report.

How to I structure a query to concatenate the result of these two queries?

Thanks in advance ...

Bob.

 

[Bob Howard]

Discovered something called a Union query. It tested out fine (only
implemented about 10% of the fields for the test, but can see that this is
the answer)! Thanks anyway!! Bob.