Columns to Rows

[ezfriend]

I have a query that returns something like this.


Field1 Field2 Field3
--------------------------------
232 223 344

I want to display it as

Field1 232
Field2 223
Field3 344

How can that be done? Please point me to the right direction if you can.

Thanks.

Note: Field1-3 are column headers.

 

[pbaldy]

You could use a UNION query to achieve that.

 

[ezfriend]

Yes, infact that's what I have right now, but it involves creating many select statements for each field. Unless I don't know the UNION query well enough.

I thought there could be something easier in the Pivot view, but I couldn't get it to work.