MS Access - Loop and Concatenate
Posted on 2011-03-18
I have a query that gives me a list of products by country. I would like to concatenate the products separated by a comma onto one line for each country. How do I create a loop so that I can use this in a report?
Here's the query
SELECT DISTINCT COUNTRY.COUNTRY_DESC, VARIETY.VARIETY_NAME, VARIETY.VARIETY_ORG_ID
FROM (RPT_LINE_ITEM INNER JOIN COUNTRY ON RPT_LINE_ITEM.RPT_LINE_ITEM_COUNTRY_ID = COUNTRY.COUNTRY_ID) LEFT JOIN VARIETY ON RPT_LINE_ITEM.RPT_LINE_ITEM_VARIETY_ID = VARIETY.VARIETY_ID
ORDER BY COUNTRY.COUNTRY_DESC;