How to create separate charts for each customer from Access query

[Guest]

I would like to create a separate chart automatically for each customer based
on a query. The idea is not to run separate reports for each customer.
Instead it would be one report but each graph would be for one customer only
and combined with others.


Thank you

 

[Duane Hookom]

You can create a report based on a record source of each customer. Then use
the Chart control in the detail section of the report with the appropriate
customerID field in the Link Master/Child properties.