Easy way to transpose a query view

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

Guest

I have a table with many fields (columns). I want to compare 3 rows. The best
way to do that is to have the 3 rows in columns and then all the field values
as rows.

Is there an easy way of transposing the normal table view to this other
format?
 
I don't believe there's any easy way.

You might be able to rig up a UNION query that does it (you could use VBA to
generate that query), but there's a 32 table limit on UNION queries, so
that's not going to help all that much.

Probably best to create a temporary table with the appropriate data, or dump
the data into Excel, and work with it there.
 
Back
Top