From: auujxa2 via AccessMonster.com on
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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/201005/1

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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/201005/1

From: Duane Hookom on
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.

--
Duane Hookom
MS Access MVP


"auujxa2 via AccessMonster.com" <u37567(a)uwe> wrote in message
news:a872542533dc3(a)uwe...
> 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
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/201005/1
>