Hi,
I need to display the out put of a table as chart in ms access 2007. My table is as below.
ItemID Week 1 Value Week 2 Value 1001 87 5 1002 80 1 1003 42 1 1004 55 164
In the chart X co ordinate should be the "ItemID" and the Y co ordinate should be the week number (eg, week1, week2 ...etc).
Is it possible to display the chart with the above table? Or do I need to transform the table and then dosplay as chart?
Also can I transform the above table as shown below using a single Transform query ?
ItemID Week Value 1001 1 87 1001 2 5 1002 1 80 1002 2 1 1003 1 42 1003 2 1 1004 1 55 1004 2 1664
Also please let me know if I can transform the table as above is it possible to create the chart.
Please help me resolving these.