Crosstab query

M

mcarter

I have a table with fields f1, f2, f3, name1, name2, name3, name4, f4, f5.

I need the table to look like f1, f2, f3, name, f4, f5 where it would list
the
name1-name4 in rows instead of columns. (ie reverse crosstab).

How do I transpose this table so that the names are in 1 field (in 4 rows)
instead of
4 separate fields in 1 row?

Thanks in advance!
 
K

KARL DEWEY

Use a union query something like this --
SELECT f1, f2, f3, name1 AS NAME, f4, f5
FROM YourTable
UNION SELECT f1, f2, f3, name2 AS NAME, f4, f5
FROM YourTable
UNION SELECT f1, f2, f3, name3 AS NAME, f4, f5
FROM YourTable
UNION SELECT f1, f2, f3, name4 AS NAME, f4, f5
FROM YourTable.
 
Top