swap columns and rows

[mbar]

Hi-

I need to switch columns and rows. here's what I currently have:

loc, shift, dep, mc, disc, amex
40, 1, 100, 200, 300, 400
40, 2, 150, 250, 50, 20
40, 3, 50, 25, 60, 100
41, 1, 500, 300, 600, 400
41, 2, 175, 20, 50, 200
ect..

Here's what i need:

loc, type, shift1, shift2, shift3, ect..
40, dep, 100, 150, 50
40, mc, 200, 250, 25
40, disc, 300, 50, 60
and so on....

is this a union query?

any help would be greatly appreciated.

thanks in advance!

 

[Beetle]

Looks like you need a crosstab query. There is a built in crosstab query wizard that can walk you through it.