How to get multi row data of one column to one row of one Column

[generalpio]

Hi friends,

I need to get data in multiple row of one column.

For example data from that format

ID Interest
1. Sports
1. Cooking
2. Movie
2. Reading

to that format

ID Interest
1. Sports,Cooking
2. Movie,Reading


I wonder that we can do that in MS Access sql. If anybody knows that, please help me on that.

[Jim Doherty]

Rather than reinvent the wheel here...have a look at this thread and in particular the 'Concat' Function that is mentioned therein it will cover your need
Combining Rows-Opposite of Union

Welcome to Bytes :-)