Do you really need a sub-report to do what you want? I can't tell from your
description. I only proposed doing this in a sub-report because of your
subject line.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Mervyn Thomas wrote:
I guess I would need to get the multiple columns into a subreport and then
insert this into the main report which can only handle one column. I am
not too sure how to accomplish this in practise!

"John Spencer" wrote in message
...
In a sub-report you can have multiple columns but you must use across then
down layout and not down then across. If that does not solve your problem
then you are going to need some complex coding to identify which records
go in column 1, 2, and 3. You would still need to used the across then
down setup.

To set up multiple columns, you use page setup. Found under the File menu
in versions of Access prior to Access 2007.

Hope this helps solve your problem.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Mervyn Thomas wrote:
I have a members database with people divided into groups or categories
etc. The report I am trying to do is have many columns at the group
header level with only one field - the fullname of all those members in
the detail section for that group. What I would like to have is
this information is snaked through about 3 columns in this detail
section. Is there any way of doing it? Could it be a macro?
Except I cannot think how to go about it!