My query [qryIssue6_3MoRates] has 3 fields: CalMonth, Issue, 3MoRate. There is 360 records - 24 Months x 15 Issues, with the 3MoRate value for each.
qryIssue6:
SELECT qryIssue4.CalMonth, qryIssue4.Issue, IIf(Sum([qryIssue4_1].[SRD])=0,0,Sum([qryIssue4_1].[Ex])/Sum([qryIssue4_1].[SRD])*100) AS 3MoRate
FROM qryIssue4 INNER JOIN qryIssue4 AS qryIssue4_1 ON qryIssue4.Issue = qryIssue4_1.Issue
WHERE (((qryIssue4_1.CalMonth)>DateAdd("m",-3,[qryIssue4].[CalMonth]) And (qryIssue4_1.CalMonth)<=[qryIssue4].[CalMonth]) AND ((qryIssue4.CalMonth)>=#11/1/2004# And (qryIssue4.CalMonth)<=#10/31/2006#))
GROUP BY qryIssue4.CalMonth, qryIssue4.Issue
HAVING (((Count(qryIssue4_1.CalMonth))>2));
I want the report to show 15 line graphs - 1 graph for each of 15 Issues. Each graph would show 3MoRates over 24 months.
Everything I try ends up with 1 or 15 graphs that each have 15 points (in the same series) for each month. I also tried setting both the report record source and the graph record source to the query, creating a grouping header for Issue, and linking parent and child fields to Issue. I have another graph where this works, but when I do same for this one the graphs show up empty (the border is there, but no axis labels, gridlines, title, etc.). The Issue shows up 15 times, each with the border of the graph. Every property is identical other than query and field names, but one works and one doesn't.
Any help understanding how to create a graph like this would be very appreciated.
Thanks!
Mike
qryIssue6:
SELECT qryIssue4.CalMonth, qryIssue4.Issue, IIf(Sum([qryIssue4_1].[SRD])=0,0,Sum([qryIssue4_1].[Ex])/Sum([qryIssue4_1].[SRD])*100) AS 3MoRate
FROM qryIssue4 INNER JOIN qryIssue4 AS qryIssue4_1 ON qryIssue4.Issue = qryIssue4_1.Issue
WHERE (((qryIssue4_1.CalMonth)>DateAdd("m",-3,[qryIssue4].[CalMonth]) And (qryIssue4_1.CalMonth)<=[qryIssue4].[CalMonth]) AND ((qryIssue4.CalMonth)>=#11/1/2004# And (qryIssue4.CalMonth)<=#10/31/2006#))
GROUP BY qryIssue4.CalMonth, qryIssue4.Issue
HAVING (((Count(qryIssue4_1.CalMonth))>2));
I want the report to show 15 line graphs - 1 graph for each of 15 Issues. Each graph would show 3MoRates over 24 months.
Everything I try ends up with 1 or 15 graphs that each have 15 points (in the same series) for each month. I also tried setting both the report record source and the graph record source to the query, creating a grouping header for Issue, and linking parent and child fields to Issue. I have another graph where this works, but when I do same for this one the graphs show up empty (the border is there, but no axis labels, gridlines, title, etc.). The Issue shows up 15 times, each with the border of the graph. Every property is identical other than query and field names, but one works and one doesn't.
Any help understanding how to create a graph like this would be very appreciated.
Thanks!
Mike