ReOrganize table Thru query for chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table that is actually based on a query. it is organized like below.
i need it to produce a query to feed a Chart. any ideas? a crosstab query
won't feed the chart.

tblOriginal
Date Rejects Approvals NonInspects
28 Feb 06 3 20 8
1 Mar 06 4 28 12
2 mar 06 3 32 10

qryOutputToChart
Status WeeklyTotals
Rejects 10
Accepts 80
NonInspects 30
 
You should be able to use a union query:

SELECT "Rejects" as Status, SUM(Rejects) as WeeklyTotals
FROM tblOriginal
UNION ALL
SELECT "Accepts", Sum(Approvals)
FROM tblOriginal
UNION ALL
SELECT "NonInspects",Sum(NonInspects)
FROM tblOriginal;
 
Back
Top