Transposing fields!

A

Aran Black

How do I transpose the result from a Select Query?

I have 10 fields in a table and when I query them they give me back 10
fields!! I want to turn the fields into rows! Can this be done? I can give
specifics if this will help! I cant work this one out at all!

Aran
 
K

Ken Snell \(MVP\)

Use a Union query:

SELECT Field1
FROM Table
UNION ALL
SELECT Field2
FROM Table
UNION ALL
(etc.)
 
Top