How to combine multiple row values into one column

[Bill Murphy]

I have a table where there could be multiple rows for each lender which I would like to combine in a query. For example:

Lender Property Type
Lender A Apartment
Lender A Office
Lender A Industrial
Lender B Hotel
Lender B Retail

I would like to combine the property types into one column for each lender in the result set like:

Lender Property Types
Lender A Apartment, Office, Industrial
Lender B Hotel, Retail

I believe this could be done with a cross tab query, but I can't come up with the query structure. Any thoughts will be appreciated.

Bill

 

[Douglas J. Steele]

What you're trying to do is generally referred to as concatenation.

There are a couple of examples at "The Access Web"
http://www.mvps.org/access/modules/mdl0004.htm and
http://www.mvps.org/access/modules/mdl0008.htm

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



I have a table where there could be multiple rows for each lender which I
would like to combine in a query. For example:

Lender Property Type
Lender A Apartment
Lender A Office
Lender A Industrial
Lender B Hotel
Lender B Retail

I would like to combine the property types into one column for each lender
in the result set like:

Lender Property Types
Lender A Apartment, Office, Industrial
Lender B Hotel, Retail

I believe this could be done with a cross tab query, but I can't come up
with the query structure. Any thoughts will be appreciated.

Bill

 

[Bill Murphy]

Doug,

Thanks!

Bill