How to create a graph in a report - results from 2 subreports

[debq]

Hello,

I have created an Access Report that contains 2 subreports. One subreport uses a query as its data source (qryclinic_level_report) and provides data from the main results table on a clinic level. The other subreport uses the main results table as its source to provide overall results for all clinics. I want to create a graph to compare the percentage column on the clinic level subreport to the percentage column on the overal results subreport.

Can I create a graph using two data sources, a query and a table?

 

[genomon]

Yes. Code the RecordSource of the graph object as a SQL SELECT statement with an INNER JOIN between the table and the query.

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."