I am a beginner programmer and have created a report based on a query from two tables. Now I want to create a line graph from a different table but in the same report. I tried to use the insert a chart wizzard but with little success. The trouble is with the SQL created in the row source. Can anyone help me with the correct code (SQL) to have in the Row Source property. Here is my database structure:
Week # | MS Scrap Qty | Assembly Scrap Qty | etc...
___________________________________________________
1 | 13 | 25 | etc...
2 | 6 | 30 | etc...
I need to create a line graph like this.
|
| Y Axis
|Quantity Scrap
|
|
|
|
|___________________________________
Week 1 Week 2 Week 3
X Axis
Series data are the departments scrap qty: Machine Shop, Assembly, ect.
The SQL the wizzard put in the source box is:
TRANSFORM Count(*) AS [Count] SELECT [Week #] FROM [Graph Test] GROUP BY [Week #] PIVOT [Assembly];
This does not work.
Please Help!
Week # | MS Scrap Qty | Assembly Scrap Qty | etc...
___________________________________________________
1 | 13 | 25 | etc...
2 | 6 | 30 | etc...
I need to create a line graph like this.
|
| Y Axis
|Quantity Scrap
|
|
|
|
|___________________________________
Week 1 Week 2 Week 3
X Axis
Series data are the departments scrap qty: Machine Shop, Assembly, ect.
The SQL the wizzard put in the source box is:
TRANSFORM Count(*) AS [Count] SELECT [Week #] FROM [Graph Test] GROUP BY [Week #] PIVOT [Assembly];
This does not work.
Please Help!
