Access consolidation query

[Becky36]

Hello,

I currently have a table that has the following fields and data.

UniqueID Number
1 101
1 105
2 200
2 250
2 550

I would like to run a query to produce the following (consolidating each unique ID to one line entry and append all numbers separated by a comma into one field).

UniqueID Number
1 101, 105
2 200, 250, 550

Any help would be very appreciated.

Thanks in advance.

Becky

 

[Remou]

Have a look in the Access FAQs for 'concatenate'.

 

[PHV]

Have a look here: faq701-4233

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886