Group text field

[DanielY8]

Hi, I am trying to create a query that groups a text field, so from data that looks like this:

Code     |      Description
Part1        |    DescriptionA
Part1       |     DescriptionB
Part2        |    DescriptionC

I want to get these results,

Code     |      Description
Part1       |     DescriptionA, DescriptionB
Part2      |      DescriptionC

Is such a thing possible? I thought it might be somehow done with a grouing query, but haven't had any success. Can anyone help?


Much appreciated

[hertfordkc]

How many "Descriptions" might you have? I have created a crosstab query with a column for each type of "Description", but haven't tried to consolidate the columns into one.

[DanielY8]

The number of descriptions vary from 1 to max 5(I think).

[hertfordkc]

I have a doctor's appointment this morning, so won't have time to get an example for you. Try using the query wizard to create a crosstab query. It may take two tries, but it should give you the arrangement you want.

[DanielY8]

Thank you very much, I have just tried to do a quick one and it looks like it will work. Some small refinements and all should be fine. Thankyou very much