Concatanating Multiple Rows with a Query

[Guest]

I have a query problem that I'm sure has come up before, but I couldn't find
a thread with it, so any help or links to other threads would be appreciated.

So I have a table in Access 2003 that has two columns, gameID and Category.
Games are allowed to have multiple categories and the table looks something
like this:

gameID Category
---------------------
123 video game
123 war game
123 turn-based
456 board game
456 war game

What I want is to create a table that concatenates all the categories for
one game and has an output that looks like:

gameID Category
--------------------
123 video game, war game, turn-based
456 board game, war game

Some games have as many as 8 categories while some may only have 1. Any
direction as to an SQL statement I could use or a way to do it in the query
design would be great.

Thanks!

 

[Guest]

There have been dozens of threads in the past few years asking this same
exact question. One solution is the generic function found in the sample at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.