Two column report format

[TimTDP]

In Access 2010 I have created a 2 column report. I have a grouping on a field called "PrintType" The data gets displayed like this:

PrintType..........data
data..................data
data..................PrintType
data..................data

I want the report to display as follows:
PrintType.......PrintType
data...............data
data
data
data
data

How do I do this?

Many thanks

 

[vbaInet]

Tim, I don't follow. Perhaps you can show us a screenshot of your current report and a spreadsheet of how you would like it.

 

[TimTDP]

Many thanks

Attached

AccessReport is what I get in Access
HowIWantIt is what I want it!

The graphics only show 2 print types. Please bear in mind that at run time the number of print types could be 1,2,3,4 or 5. And could increase in the future. It is not a given that all print types are shown at the same time. i.e a report may have print types:
* 1
*1,2 3
* 2,5
* 2,3,4

Thanks very much

 

[vbaInet]

On the ribbon, Page Setup tab > Page Setup button > Columns tab > Number Of Columns = 2.

This link might help too:

http://office.microsoft.com/en-us/access-help/customize-a-multiple-column-report-HP005187423.aspx