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

  • Thread starter Thread starter Phil Smith
  • Start date Start date
P

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
 
Phil said:
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
Click to expand...


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'
 
Back
Top