Create a chart from a query, filtering data?

[Kirsti]

Hi I have a query that has 3 columns.



Name, Total Outcomes and Outcome Description.

I need to create a separate pie chart for each Name.

I am just wondering if it's possible to filter on the Name from within the Report Graph?

Obviously, I can create a separate query for each Name, but I would prefer not to.

Any suggestions?

Kirsti

[June7]

One way is to put the graph object in the Detail section of report. Report has record source that includes the Name field. The graph RowSource sql statement can include a WHERE clause that refers to the Name field of the report as criteria. I've never been able to make the Master/Child link properties of graph work.

[Kirsti]

Works perfectly. Thank you again June!