Stacked report with multiple columns

[BeachRum1962]

I have a stacked columnar report with detail that currently runs vertically (i.e., the labels are on the left with data detail in 1 column with the next section of the report starting below running vertically). I want the report to be stacked but want the data to run left to right or horizontally like a spreadsheet with labels in column A and data1 in column B, data2 in column C, etc. I am using a multi-select list box to select items from a query and that is what drives the report. I anticipate only being able to have 3 or 4 columns of data on a landscape view. Is this possible?

[June7]

Here is one way to do this http://www.datapigtechnologies.com/f.../crosstab.html

How many data values are there?

[BeachRum1962]

42 data values. I.e. there are 42 labels running top to bottom (which is what I want), however, I want the data to populate the report from left to right not continuing after the first set of 42.

[June7]

So you will have Data1 through Data42? Did you review that video?

[BeachRum1962]

Yes, reviewed the video and still trying to see if I can use that approach

[BeachRum1962]

Not sure the crosstab query is what I need since I am not summing anything, just reporting. I have all the data for the report I need, I just want it arranged differently in the report. Basically I need to just reorganize the report I currently have, making the data values repeat as columns (left to right) and not continue downward from top to bottom.

[June7]

The video shows a method to 'rearrange' the data. It 'pivots' the data using expressions in the query grid. You can do this without having to do a Totals query.