Hi,
I have a Access db that uses Access Graphs in the reports.
The reports work fine and creates the graphs with no problem from within access.
I have now had a request to display another line in the graphs.
Line 1: Performance (Line already showing)
Line 2: Target (I need to add a new line for this)
I have created a new tbl to store the targets (for 40 sites).
How do I get the crosstab query to return both the performance data and target data and use them on the same graph?
IE:
Target 40% (Same for each month of the year)
Actual: 42% (Varies month by month depending on data)
Any help will be appreciated.
Daz...
I have a Access db that uses Access Graphs in the reports.
The reports work fine and creates the graphs with no problem from within access.
I have now had a request to display another line in the graphs.
Line 1: Performance (Line already showing)
Line 2: Target (I need to add a new line for this)
I have created a new tbl to store the targets (for 40 sites).
How do I get the crosstab query to return both the performance data and target data and use them on the same graph?
IE:
Target 40% (Same for each month of the year)
Actual: 42% (Varies month by month depending on data)
Any help will be appreciated.
Daz...
