I am attempting to export customer data from MS Access to MailChimp.
My MailChimp List uses a Group called "Interests".
So a customer can nominate 0-4 interests: Interest1, Interest2, Interest3, Interest4.
I have a Crosstab query that outputs the customer interests in this form:
The complication is that MailChimp rolls Interests in to a single field, for example:
"Interest1, Interest2, Interest3, Interest4" - if customer is interested in all 4 topics
"Interest1, Interest4" - if customer is interested in these 2 topics
"" - if customer has not specified any interests
Is it possible to generate this type of output using SQL?
Here is a sample MS Access database for testing