Grouping by Year in Column Chart

[trwebster]

I have a query that shows:

YearOpen County Countofnumber

The data is sorted by year and I created a report that shows the list of counties grouped by year (one year on each page). I inserted a chart into the YearOpen footer, but I only want the chart to show one year on each page; right now it shows all years.

This is my row source:

TRANSFORM Sum([CountOfnumber]) AS [SumOfCountOfnumber] SELECT [Open Year] FROM [trw Migrant Cases Opened - County] GROUP BY [Open Year] PIVOT [case_county];

If I link the master/child fields, I get nothing and if I leave them blank I get all years in the chart.

Is there any way I can group the chart to show only one year on each page?

 

[dhookom]

Using the Link Master/Child should work provided you have entered the right field name(s). There are often some latency issues with graphs on reports. ACG Soft has some tips regarding this on their web site

http://ourworld.compuserve.com/homepages/attac-cg/acgsoft.htm.

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]

 

[trwebster]

I went through Insert|Chart again and it seems to be working after choosing the correct Master/Child link.