Linking charts

  • Thread starter Thread starter ladybug via AccessMonster.com
  • Start date Start date
L

ladybug via AccessMonster.com

I have two charts on a report. The charts are both controlled by the same
query. When I open the report I am prompted for the criteria from the query
twice.

The First Chart represents two different series of data.
The Second Chart represents the avg between the two series in the chart above.

This is why I am splitting them into two different charts even though they
come from the same query.

How can I open the report and only have to enter the criteria data once?
 
Hi

When the button to run the report is pressed have it open a form instead.
On this form have inputs for the parameters required by the query and a
button to launch the report.
Alter the query to use the parameters on the form.

E.g. if the query where clause is like this now...

WHERE tblMyTable.DateField = [StartDate]

make it...

WHERE tblMyTable.Datefield = [Forms]![MyNewForm].[StartDate]

Hope this helps

Andy Hull
 
Back
Top