Combining fields in one row - how?

[Chelle]

I have a table with several columns of data that point to
a specific col. The common field is the Client Col. next
few columns are Companies that sold Products to the
Client. In my table, I have several duplicates of the
Client co name and on each row there is a Company Product
associated to that Client. I need to know how to bring
all the fields from each company product column/row into
one row. I have too many rows of data for the same
client. I only need one row of data with all the company
columns info in that row. Thanks for any help!

 

[Bas Cost Budde]

I have a table with several columns of data that point to
a specific col. The common field is the Client Col. next
few columns are Companies that sold Products to the
Client. In my table, I have several duplicates of the
Client co name and on each row there is a Company Product
associated to that Client. I need to know how to bring
all the fields from each company product column/row into
one row. I have too many rows of data for the same
client. I only need one row of data with all the company
columns info in that row. Thanks for any help!

Create a Crosstab query.

 

[Duane Hookom]

Consider using the generic concatenate function found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. This
function can take data like:
CompanyA Prod1
CompanyA Prod2
CompanyA Prod3
CompanyA Prod4
CompanyA Prod5
into:
CompanyA Prod1, Prod2, Prod3, Prod4, Prod5