From: auujxa2 via AccessMonster.com on 23 May 2010 15:06 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 23 May 2010 16:38 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 24 May 2010 00:21 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 >
|
Pages: 1 Prev: email recipient address shows twice Next: Grouped/Sorted Report by Month |