Access: Concatenate values from multiple records into one text string
Posted on 2011-03-15
Hopefully this is a simple one, I've got a list of contacts email addresses in a report and I'm tring to join them into one text string located in a text box on the report to eventually copy paste into an email client, that would at least be a start anyway.
The query the report is based on lists [Name] [Email] [Address1] etc.
I've got no problem combining fields from the same record,
eg, [Name] & ", " & [Email]...
but how do I go about combining the values from multiple records into one string,
eg, [Email] & "; " & [Email] & "; " & [Email]...
I've seen a few concatenate solutions involving VBA code but I'm new to that so don't really know where to begin. Most other solutions are for slightly more complex situations than this so I'm wondering if there are any basics I've missed.