Can Access Reports allow graphs to automatically update??

[FCGAccess]

We are working on a report which is pulling from a table database with a number of levels. We are having each provider placed onto a new page within the report we've created. We like the graphs being placed on the reports for a nice easy clear visual of what the report is telling us. The problem though is that we will want the graphs to update each time we run them in the event the tables have changed and want them to match the data for each provider on each of the pages.

Can Access do this or are we asking too much?

 

[dhookom]

You would be "asking too much" if you didn't want the charts to update with the new/updated records.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[dhookom]

I should have added that a chart is basically a graphical presentation of "subreport" data. Just like a subreport has a record source, a chart has a row source. A chart can be set to Link Master/Child like a subreport.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]