Print Records Horizontally

[Tim]

Is there a way to print records horizontally on a
report? For example, I have a report similar to this:

Grouping1
Record1
Record2
Record3

and I would like it to look like this:

Grouping1
Record1 Record2 Record3

Thanks in advance for your help.
Tim

 

[Duane Hookom]

You can use a multi-column subreport of the records and place it on a main
report that contains only the unique Groupings. Another option is to
concatenate the records. There is a sample file at
http://www.rogersaccesslibrary.com/OtherLibraries.asp. Look for Generic
Function To Concatenate Child Records (46 KB) .

_____________
Duane Hookom
MS Access MVP

 

[Tim]

I couldn't get the subreport to work the way I wanted it
to, but the sample file that you pointed me to was
exactly what I needed. Thanks for your help.

Tim