Linking queries on a report

[Brennan]

Hello all,

I built a number of queries that all tie to the same table. Each query
sorts the data differently, but comes from the same data source. I would
like to show the results of these queries on the same report, but I get and
error message that the wizard can't connect the queries. How can I display
multiple queries on the same report. I've tried subreports, but they don't
seem to export as well. Thanks

b

 

[Jeff Boyce]

Brennan

What does "export" have to do with this?

If I have multiple sets of results I want to show in one place, I create an
empty "main" report, then put each of the result sets (i.e., query results)
into its own (sub-)report and embed those all in my main report.

Regards

Jeff Boyce
Microsoft Office/Access MVP