many-many relationship: how to provide all values related to one record in a given field

[tschaeffer]

Not sure how to do this.

I have table of data for reports written, and a table of countries we write
reports on. Each report can cover many different countries, and a country
can be covered in any report. Many - many relationship.

I'd like to run a report that for the query results below:

ReportID CountryID

1000020 Td

1000020 Tz

1000020 Ug

1000020 Zm

1000020 Zw

1000035 Ao

1000035 Mz



will provide the output below:

1000020 Td;Tz;Ug;Zm;Zw

1000035 Ao;Mz



Any suggestions? This would be very helpful.

Thanks - Toby

 

[Duane Hookom]

There is a generic Concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[tschaeffer]

Exactly what I was looking for. Thanks.

There is a generic Concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.
--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm