How2:Display data from multiple Records on one line seperated byCommas

[Phil Smith]

Here is My Data in [Products]

Category Item
======== ==========
Fruit Apples
Fruit Oranges
Fruit Bananas
Nuts Peanuts
Nuts Cashews
Nuts Almonds
Nuts Pistachios
Candy Mars
Candy Snickers
Candy M&Ms
Candy Baby Ruth

What I want to see in areport and ideally a query as well, is:


Category Items
======== ==================================
Fruit Apples,Oranges,Bananas
Nuts Peanuts,Cashews,Almonds,Pistachios
Candy Mars,Snickers,M&Ms,Baby Ruth


Not sure how I woudl go about this one. Ideas please?

Phil

 

[Marshall Barton]

Here is My Data in [Products]

Category Item
======== ==========
Fruit Apples
Fruit Oranges
Fruit Bananas
Nuts Peanuts
Nuts Cashews
Nuts Almonds
Nuts Pistachios
Candy Mars
Candy Snickers
Candy M&Ms
Candy Baby Ruth

What I want to see in areport and ideally a query as well, is:


Category Items
======== ==================================
Fruit Apples,Oranges,Bananas
Nuts Peanuts,Cashews,Almonds,Pistachios
Candy Mars,Snickers,M&Ms,Baby Ruth

You need to create a function to do that. There's a good
one at:
http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'