James:
You need to use a Union query and you need to select the
same fields and field names from each table. If a field
does not exist or has a different name you can rename it
in the query. I always make sure I have the same fields
with the same field names in the same order.
In this example, there is not a Middle Initial field in
tblTable2 and the fields are named differently in each
table:
SELECT tblTable1.FirstName, tblTable1.MiddleInitial,
tblTable1.LastName
FROM tblTable1
UNION SELECT tblTable2.FNAME AS FirstName, NULL as
MiddleInitial, tblTable2.LNAME AS LastName
FROM tblTable2;
Hope this helps!
Howard Brody
