Crosstab quesry

[99Chuck99]

Is it possible to create a crosstab/pivot query to change output from this table.

SORT MONTH YEAR ENG FSEU LOG
0 Oct 2009 2 8 0
1 Nov 2009 9 13 6
2 Dec 2009 9 17 6

to this

DEPT MONTH COUNT
ENG OCT 2
FSEU OCT 8
LOG OCT 0
ENG NOV 9
FSEU NOV 13
ECT....

Thanks in advance

 

[dhookom]

I believe you could use a normalizing union query like:

SELECT [Sort], [Month], [Year], "ENG" as Dept, [Eng] as Cnt
FROM tblUnnormalized
UNION ALL
SELECT [Sort], [Month], [Year], "FSEU", [FSEU]
FROM tblUnnormalized
UNION ALL
SELECT [Sort], [Month], [Year], "LOG", [LOG]
FROM tblUnnormalized
ORDER BY 1,4;

Duane
Hook'D on Access
MS Access MVP