Multiple table listing

  • Thread starter Thread starter Howard
  • Start date Start date
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
 
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.
 
Back
Top