Creating a report with more than one data source

[Bethey99]

I need to create a report that includes information from more than one query. I also want to include graphs so that the numbers will mean more to my clients. I cannot add another query to my report and I cannot keep my data together. Is there a way to make mini-tables in reports? I'm looking for any way to fix this problem.

 

[RpbertS]

im not sure what you mean by you cannot add another query to your report..how come you can not?

-Rpb

 

[Bethey99]

I can set the properties to have one query for the data but I do not know where I add another query to the report. Is this my problem?

 

[Pat Hartman]

You can create a third query that joins the first two queries on their common key fields and use the third query as the report's recordsource.

 

[Neal]

Perhaps you need to create a subreport. It can have a different record source than your main report.

 

[Maryanne]

I had a similar problem (which I didn't explain well). If you cannot create a query that links your other queries, then use reports/subreports. According to Access Help you can create an unbound main report and nest subreports in that if there are no fields that you can use to link a main report/subreport (i.e. customers/orders)