K
kdub32
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!
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!