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.