ReOrganize table Thru query for chart

[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

 

[Duane Hookom]

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;

 

[Guest]

Looks like it makes sence. i'll give it a try, thanks.