new crosstab option?

[auujxa2 via AccessMonster.com]

I have a table that displays results horizontal, that needs to be verticle,
so it shows up on a report in one page, instead of one record per page.

example:
table:

PRODUCT: TYPE: LEAKS:
UNLEAD STP YES
DIESEL STP NO
PREMIUM STP NA

Need this on a one page report:
product: UNLEAD DIESEL PREMIUM
type: STP STP STP
leaks: YES NO NA

any ideas?
thanks

 

[PieterLinden via AccessMonster.com]

This worked... Not sure you could do it as a query, but then I didn't really
try...
http://support.microsoft.com/kb/202176

 

[Duane Hookom]

I would probably create a multi-column report. You might want to search the
MS KnowledgeBase articles for the one that explains how to create a multiple
column report with labels on the left.