Transposing fields!

  • Thread starter Thread starter Aran Black
  • Start date Start date
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
 
Use a Union query:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transposing data in Access 2007 Query 1
query too complex when transposing 2
Split data in field on character return 0
Transpose Access Table / Query 5
Field Name in a Table 4
Transpose Data that involves subquery 0
transpose field titles syntax help needed 7
Transpose 2 rows to 2 columns 1

Back
Top