Switch columns in a query or report

[Lisa]

Hello.
I need to swap my rows and colums. I am not sure if this
can be done or not. If I do a crosstab I can only have
one row of information when actually I need 5. Is there
any way that this can be done? If you need more
information, please email me at (e-mail address removed).

Thanks for your help,
Lisa

 

[Duane Hookom]

You might need to provide a sample of your current data and what you want
your final display to look like. You may need to first create a normalized
result set using a UNION query and then create a crosstab from the union
query.