How to create a report based on multiple queries in Access%3f

[Claire]

I'm trying to figure out how to have the tables or queries related so that I
can use them all in a report. I can't join the queries because this will
make the query to complex and I can fit all the information in one query or
table.

 

[Duane Hookom]

Use subreports which can each be based on their own query.