Hi,
This may sound dumb, but I am not very experienced with Access reports and am having a terrible time getting anything but gobbly-guck back in attempting to build the following:
I have a query that has the following columns:
ClinicID, ClinicName, Quarter, and CommunicationAvgScore
What I want to do is create a report with a chart for each clinic showing their CommunicationAvgScore (y axis) by Quarter (x axis). I want this report to be by clinic, so I want a page break between each clinic's chart. The CommunicationAvgScore is somewhere between 0 and 5, so that should be the y axis increments.
Seems very simple, yet I'm having a difficult time of this. Can someone walk me throuhg the steps of how to do this? Seems I would need a main report form for the ClinicName and a sub form for the chart, but I don't know how to bind the two correctly either.
This may sound dumb, but I am not very experienced with Access reports and am having a terrible time getting anything but gobbly-guck back in attempting to build the following:
I have a query that has the following columns:
ClinicID, ClinicName, Quarter, and CommunicationAvgScore
What I want to do is create a report with a chart for each clinic showing their CommunicationAvgScore (y axis) by Quarter (x axis). I want this report to be by clinic, so I want a page break between each clinic's chart. The CommunicationAvgScore is somewhere between 0 and 5, so that should be the y axis increments.
Seems very simple, yet I'm having a difficult time of this. Can someone walk me throuhg the steps of how to do this? Seems I would need a main report form for the ClinicName and a sub form for the chart, but I don't know how to bind the two correctly either.
