Crosstab on two rows

[Adam Milligan]

Using Access 2007 on Windows Vista: I am using a crosstab query in a report
and it is working well, except that when I get more than 8 results it cuts
off the later results. I am looking for a way to display all of the
information in a crosstab query on a report. Is there a way to force a
crosstab onto two "rows"? I am frightfully afraid that the answer is "no",
but you folks never cease to amaze me. SQL below (mostly generated by wizard)

TRANSFORM Sum(qryHistoryRaw.SumOfnumAnswer) AS SumOfSumOfnumAnswer
SELECT qryHistoryRaw.strGroup AS [Group]
FROM (qryHistoryRaw INNER JOIN tblTestAdministration ON
qryHistoryRaw.numTestAdministrationID=tblTestAdministration.anuTestAdministrationID)
INNER JOIN qryAllRespondents ON
tblTestAdministration.numRespondentID=qryAllRespondents.anuRespondentID
GROUP BY qryHistoryRaw.strGroup
ORDER BY Format([dteDate],"yyyy-mm-dd") & " - ID: " &
[anuTestAdministrationID]
PIVOT Format([dteDate],"yyyy-mm-dd") & " - ID: " & [anuTestAdministrationID];

Thanks!

Adam Milligan

 

[Duane Hookom]

There is a demo of several crosstab reports at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. The
crosstab.mdb has a dynamic report that creates multiple levels when too many
columns would be generated.