How to change the orientation of a report

[kat50]

Hello Folks.

Does anyone know how to change the orientation of a report? I would like to have the field names on the left side from top to bottom with my summary data to the right of the field names - instead of accross the top from left to right with the data beneath.

Thanks so much!

 

[ajetrumpet]

maybe a crosstab query would assist?

 

[kat50]

Thanks for the quick response I beleive I have more fields to sumarize than I can do in a cross-tab query...