Concatenate Names

[fredka]

I have a table that has a field named GroupNumber. There is an additional field named "funding" I want to create a query that will give me one group number for each row and concatenate all of the "funding" values into one field.

For example, the data is:

Group Funding
11111 Fully Insured
11111 Fully Insured
11111 Prospective

I would want the values to be:

Group Funding
11111 Fully Insured, Prospective

Is there a way to do this?

Thanks so much!!!

Fred

 

[PHV]

Have a look here:
faq701-4233

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886