pivoting query

[MikeF]

Have a query, 40 records and 40 fields [changes a bit depending on data],
that I would just like to "pivot clockwise 90 degrees".

Would be the equivalent of dropping it into Excel, then copy current range
and transpose.

All the necessary values are in the records, there are no calculations
required.

Have tried numerous strategies w/pivot table view, crosstab, etc.

Any assistance will be greatly appreciated.

Thanx.
- Mike

 

[ryguy7272]

It's hard to imagine what you're looking at there (at least for me), but I'm
thinking, if you know how to do what you want to do in Excel, simply export
your data to Excel, and do the operation there.

Here are some VBA solutions for exporting data from Access to Excel:
http://www.accessmvp.com/KDSnell/EXCEL_Export.htm

Also, here's a technique for manipulating data in Excel, and doing it from
Access:
http://www.consulting-group360.com/Code.aspx

Look at the first sample on my site. Everything is explained there. Post
back if you have more questions.