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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Sorting and grouping using multiple tables 0
Access Dcount (multiple criteria) 3
Separate Form 0
Using form and subform not connecting to two separate tables 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
DMax on existing record to increment serialized # fails 1
"Run Time error 3156 ODBC Delete on a linked table TABLENAME failed" 0
form does not show all the records from two forms 2

Back
Top