Crosstab or transpose query with multiple fields (1 Viewer)

[June7]

Vertical is a property of labels and textboxes that can be set in design.

I think MarkK meant to rotate the paper, not the screen. I did a test. It sorta works.

Build the report in portrait or landscape orientation, print it then turn paper for reading. However, don't see how report and page headers can be used.

 

[CJ_London]

Why not export the data to excel, transform it there (presume that gives the result required) then link to the transformed data and display as a datasheet subform in your form? All done when the form is opened

Can then display up to 255 columns

Requires use of vba and excel automation. May need some work around increasing datasheet row height

If that meets your requirement, I can put together an example later as I’m out and about today. Or someone else can….