If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
new crosstab option?
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/For...ports/201005/1 |
#2
|
|||
|
|||
new crosstab option?
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/For...ports/201005/1 |
#3
|
|||
|
|||
new crosstab option?
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@uwe wrote in message news:a872542533dc3@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/For...ports/201005/1 |
Thread Tools | |
Display Modes | |
|
|