Rotated Text Control Question

[Michael]

I was wanting to know if there is a non-programming way to make the report,
with the rotated text control (by the way thanks for that control it works
awesome), print the report results in the direction of the rotated text
control such as:

Header, Rotated Text control Info, Info, Info, Total etc.

Rather than.

Header, Rotated Text Control
Info,
Info
Total etc

 

[Allen Browne]

So you want to list the info horizontally, instead of listing the records
vertically.

There's a couple of approaches. The first is to make a matrix of rows and
columns. You an do that without code, by creating a crosstab query. Once you
have the query, this article explanins how to display the total and specify
the column headings:
Crosstab query techniques
at:
http://allenbrowne.com/ser-67.html

If you don't want the data listed in its own columns - merely list it all
beside the main record, you will need code to concatenate all the related
records for each of your header records. The code to do that is here:
Return a concatenated list of sub-record values
at:
http://www.mvps.org/access/modules/mdl0004.htm