Creating Columns in a Report's Detail Section

[ybazizi]

I am trying to create a report in Access that will return records in a
columnar type of format, similar to how Microsoft Word implements columns.
Does anyone know how I can accomplish this? Here is an example of what I
want to do:

2 columns:
Header1_Value1
Header2_Value1
Record1 Record5
Record2 Record6
Record3 Record7
Record4

or even 3 or more columns:

Header1_Value1
Header2_Value1
Record1 Record5 Record9
Record2 Record6 Record10
Record3 Record7 Record11
Record4 Record8

I want the columns to be dynamic enough to automatically adjust for the
number of records returned, so that records are disperced equally among the
columns.

Unfortunately this is all I seem to see available as an option (1 column)
which is making for a long report with a lot of wasted blank space on paper:

Header1_Value1
Header2_Value1
Record1
Record2
Record3
Record4
Record5
Record6
Record7
Record8

Thanks!

yba

 

[Duane Hookom]

You could use a multi-column subreport to display the record details. Without
a lot of work, this subreport would display records across then down.