Query Help

[lmossolle]

I am using the following on a Query, In this I would like to see a projected
days and a actual days. I am seeing all entries on the chart though. I only
need the 2. Could someone please assist? The projaccdays = projected days and
actdays = actual days.

SELECT Null AS Expr1,
[AMR Query].projaccdays1 AS 1,
[AMR Query].projaccdays2 AS 2,
[AMR Query].projaccdays3 AS 3,
[AMR Query].projaccdays4 AS 4,
[AMR Query].projaccdays5 AS 5,
[AMR Query].projaccdays6 AS 6,
[AMR Query].projaccdays7 AS 7,
[AMR Query].projaccdays8 AS 8,
[AMR Query].projaccdays9 AS 9,
[AMR Query].projaccdays10 AS 10
FROM [AMR Query]
UNION SELECT Null AS Expr1,
[AMR Query].actdays1 AS 1,
[AMR Query].actdays2 AS 2,
[AMR Query].actdays3 AS 3,
[AMR Query].actdays4 AS 4,
[AMR Query].actdays5 AS 5,
[AMR Query].actdays6 AS 6,
[AMR Query].actdays7 AS 7,
[AMR Query].actdays8 AS 8,
[AMR Query].actdays9 AS 9,
[AMR Query].actdays10 AS 10
FROM [AMR Query];

 

[Duane Hookom]

The issue was the un-normalized table structure. Rather than having 10
records with about 3 fields, the existing structure has 30 values in one
record. Once the table was normalized with a union query, the chart worked as
desired.