How2:Display data from multiple Records on one line seperated by Commas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Phil Smith - 12 Oct 2007 19:13 GMT

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

Reply to this Message

Marshall Barton - 12 Oct 2007 20:41 GMT

>Here is My Data in [Products]
>
[quoted text clipped - 19 lines]
>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/Otherdownload.asp?SampleName='Generic%20Funct
ion%20To%20Concatenate%20Child%20Records'

Signature

Marsh
MVP [MS Access]

Reply to this Message