I have table A which contains one set of records. I have
a query that pulls the records from Table A. The query
produces 100 records.
I also have table B which contains different fields than
Table A. I have a query that pulls records from Table B
and uses specific fields to create dummy records that look
just like those from Table A in format but that only have
a couple of fields filled in. The query produces 50
The problem: I need to merge the records from Query
A/Table A with the manufactured records from Query B/Table
B for a total of 150 records BEFORE I export them to Excel.
How do I create a 3rd query that merges the results of
Query A and Query B. I am drawing a complete blank on