Turn columns into rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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.
 
Back
Top