Trying to output results of 3 sep queries to 1 report

C

charlie

Im trying to create one report outputting 3 columns. Each
column is the result of 3 separate queries I have create
which work fine. I would just like to display the results
of these 3 queries on the one page.
I get the error message saying

You have chosen a field from a record source which the
wizard cannot connect. You may have chosen fields from a
table and from a query based on that table. Try chosing
the fields from only that table or that query.

Anybody know how to output the results of 3 separate
queries onto the one report.

much appreciated

Charlie
 
A

Allen Browne

The best solution is probably to redesign the data structure, so that your
tables are not split up and one query can grab all the data.

If that is not possible but the queries all create the 3 columns, you may be
able to switch to SQL View, and combine the 3 SQL statements into a UNION
query. Generally that's a matter of pasting the 3 statements together, and
then replacing the middle two semicolons with the word UNION.

If the queries have different columns, you may want to create 3 different
reports, and then put them all as subreports of one master (unbound) report.
 
Top