chart by month

[PHisaw]

Hi,

I'm looking for a solution to enter monthly information to a chart. I have
my report the way I want it by using calculations and sorting date field by
month. How can I do this in a chart? When I count my jobs and sum days of
each stage to complete job in query, then I can't get the month breakdown.
I've always done charting in Excel, but my info is in Access and I need this
each month. I want to automate it in some way so that users can click on
report and have most up to date info already charted.

Please help!
Thanks in advance,
Pam

 

[Duane Hookom]

It's hard to determine what you have tried, what worked, what didn't,...

The primary attribute of a chart is its Row Source property. This is
generally a query/sql statement. Most of the remainder of the chart
properties determine how the query is displayed.

Another set of properties that can be important are the Link Master/Child
properties of the chart control. These allow the designer to filter the chart
based on values in the main report much like a report with a subreport.