I'm trying to convert the e-mails in each record in the results to a single string of e-mails separated by a comma.
Advanced Beginner
Windows 7 64bit 
Access 2010 64bit
I'm trying to convert the e-mails in each record in the results to a single string of e-mails separated by a comma.
VIP
Windows 10 Access 2010 32bit
Sorry, accidental double post.
Last edited by June7; 04-28-2018 at 07:15 PM.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
VIP
Windows 10 Access 2010 32bit
You mean email addresses?
If you want to combine data from multiple related records, review http://allenbrowne.com/func-concat.html
If you just want to combine fields of single record, simply: field1 & "," & field2
Last edited by June7; 04-28-2018 at 01:46 PM.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
create list box from field with comma separated items
Updating a field with a comma separated list of values from within VBA
Convert Comma Separated List String to Records
Posting Permissions
Reply With Quote