Multiple table listing

H

Howard

I would like to print all the records from three separate
tables on one report. There are no relationships between
the tables, I just want to print all the records from one
table, followed by all the records from the second table,
followed by all the records from the third table. This is
only to save paper. Can it be done easily. Thanks!
-Howard
 
J

John Vinson

I would like to print all the records from three separate
tables on one report. There are no relationships between
the tables, I just want to print all the records from one
table, followed by all the records from the second table,
followed by all the records from the third table. This is
only to save paper. Can it be done easily. Thanks!
-Howard
Click to expand...

A UNION query will do the trick here: see UNION in the online help.
You need to go into the SQL window to do this but it's not that hard.
 
Top