Rotated Text Control Question

  • Thread starter Thread starter Michael
  • Start date Start date
M

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
 
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
 
Back
Top