How to transpose a report???

[jflo]

I have a report that has about 40 columns and a row for each ages we have a client from 0 to 114 (I know, this client of the insurance company I work for is probably dead but I don't make the entries, I just move the data around for analysis!). I want to transpose my report in order to get about 85 columns and 40 rows. (Not just change it's printer orientation!)

Excel or other Business Intelligence tools like PowerPlay from Cognos or Brio , you can easily swap the rows and columns. I'm looking for a way to achieve this without having to rebuild the report. I'm using Access97. Thanks.

 

[JoeMiller]

You can't do it in the report without physically moving the fields. You may want to look into CrossTab queries though. They can transpose data like you are suggesting very easily if your data structure supports it. Try the wizard out and also read the topic in online help.

HTH Joe Miller
joe.miller@flotech.net