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

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

For example 开发者_JAVA技巧data from that format

ID Interest

1. Sports
2. Cooking
3. Movie
4. 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.

---

Take a look at Allen Browne's approach: Concatenate values from related records

As for the normalization argument, I'm not suggesting you store concatenated values. But if you want to join them together for display purposes (like a report or form), I don't think you're violating the rules of normalization.

---

This is called de-normalizing data. It may be acceptable for final reporting. Apparently some experts believe it's good for something, as seen here.

(Mind you, kevchadder's question is right on.)

---

Have you looked into the SQL Pivot operation? Take a look at this link: http://technet.microsoft.com/en-us/library/ms177410.aspx

Just noticed you're using access. Take a look at this article: http://www.blueclaw-db.com/accessquerysql/pivot_query.htm

---

This is nothing you should do in SQL and it's most likely not possible at all.

Merging the rows in your application code shouldn't be too hard.