Concatenate Query Results

[Ganymede]

Hi. I'm not quite sure how to describe what I'm trying to achieve without an example. So here goes.

Say I have a table that looks like this.

Species	Breed
Cat	Siamese
Cat	Ragdoll
Dog	Poodle
Cat	Sphynx
Dog	Bulldog
Dog	German Shepard
Dog	Golden Retriever

I want to run a query from that table that looks like this

Species	Breeds
Cat	Siamiese, Ragdoll, Spynx
Dog	Poodle, Bulldog, German Shepard, Golden Retriever

So basiclaly in this example I collapsed all speices into one row and concatenated the results of the breeds column.



Is that something that can be done programatically in access?

[Ganymede]

Please disregard. I think I figured it out.

http://allenbrowne.com/func-concat.html

[Gustav]

If this a larger table and you want speed, you can use my function DJoin found at my repository at GitHub: https://github.com/GustavBrock/VBA.DJoin

SELECT Species, DJoin("Breed","Animals","Species = '" & [Species] & "'",", ") AS Breeds
FROM Animals
GROUP BY Species;

[Welshgasman]

A slightly easier one is https://www.accessmvp.com/thedbguy/c...itle=simplecsv