Report with data from multip sources

  • Thread starter Thread starter Neil
  • Start date Start date
N

Neil

I need to design a report which take data from multiple
table and list them all in the same report. The data is
not related. For example, table1 is a list of employees,
table2 is offices and table3 is a list of servers.

One one page the want the 3 tables showing the data. Is
this possible to do in Acess 2000?

Any ideas or solutions you have will be a great help.

Thank you,

Neil
 
One solution would be to create another report (not based on any table), and
put three subreports on it.

If the fields in the 3 tables match, it would be possible to create a UNION
query to combine the 3 tables into one. To do that, create 3 separate
queries temporarily. Switch them to SQL View. Replace the semicolon at the
end of the first one with the word " UNION", and then paste in the SQL
statement from number 2. Repeat for #3.
 
Back
Top