Turn columns into rows

[Guest]

How do you change columns into rows in MS Access?
EX:

FName LName
------------------
Bob Davis
Jeff Wilson

Into

Category Data
------------------
Fname Bob
Fname Jeff
Lname Wilson
Lname Davis

Any and all help is greatly appreciated!!!

Thanks!

 

[Guest]

This is a job for a Union query.

SELECT "FName" AS Catagory, FName AS Data
FROM tblNames
UNION ALL
SELECT "LName", LName
FROM tblNames ;

Put in the right table name.