Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Create chart on Main Report with 2 subreports, 2 data sources

Status
Not open for further replies.

debq

Technical User
Aug 7, 2008
50
US
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?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top