Forcing Reports to Print Two Sets of Data Alongside Each Other. 1

[Sanibel]

I have a number of reports in tabular form which only contain a few columns. The reports are quite long so go over a number of pages. Is there a way that I can force reports to print more than one set of data alongside each other ie to convert

ValA1 ValA2 ValA3
ValB1 ValB2 ValB3
ValC1 ValC2 ValC3
ValD1 ValD2 ValD3

into

ValA1 ValA2 ValA3 ValB1 ValB2 ValB3
ValC1 ValC2 ValC3 ValD1 ValD2 ValD3

I hae tried duplicating the fields, but as expected, that just duplicates the values.

Thanks

 

[lameid]

If you have three columns in your rowsource, you can add a column to the report.

Make sure your three controls are far to the left.

In design view, go to file and page setup.

On the columns tab, specify 2 columns or more. The width and height should encompass the three controls. The column layout at the bottom specifies whether the columns go accross then down or down then accross.

Everything but the page and report headers and footers end up in columns, so watch for wrapping.

 

[Sanibel]

Thanks very much. That was just what I was looking for.

 

[dhookom]

Good reply from lameid, deserves a star ;-)

Duane
Hook'D on Access
MS Access MVP