Laying out groups horizontally?

[eliao]

I'm laying out a very customized report and I'm stuck on
one problem. Let's say I have table called "Fruits" with 2
fields, [FruitID] and [Fruit]

FruitID Fruit
1 Apple
2 Orange
3 Grape
4 Peach

My problem is that I'd like to pull the above data on to
one field on a report [ListofFruits] so that it is
displayed as such:

Apple, Orange, Grape, Peach.

Basically, the name of the field separated by commas. What
expression do I put in the controlsource property of the
[ListofFruits] property to achieve this?

Thanks in advance for your help.

 

[Douglas J. Steele]

See whether the code in http://www.mvps.org/access/modules/mdl0008.htm at
"The Access Web" is what you need.