Concatenate several record to one string separated by ;

[Gerrit.B]

Hi,

I have a query called CC.
the results of this query are some email address.

Output that I need is:

address1@mail.com; address2@mail.com; address3@mail.com.

How can this be done?

 

[AlanY]

with emails in A1, B1 & C1, try

=A1&"; "&B1&"; "&C1

 

[Joe4]

with emails in A1, B1 & C1, try

=A1&"; "&B1&"; "&C1

Alan, this is an Access question, not an Excel one. If you were using the "Zero Reply Posts" listing when you came across this question, note that over on the right side of the screen, it shows what Forum the question is from.

Gerrit,
Are all these emails addresses in a single field, so you have multiple records with one field, or is it multiple fields within a single record?
If it is multiple records, do you want ALL the email addresses combined together, or will there be "groupings" based on another field?

 

[Gerrit.B]

Joe4,

Every email address is one record, so when I have 4 records I just need one string with 4 email address separated by a semicolon.
No other fields are necessary for my purpose.

Alan, this is an Access question, not an Excel one. If you were using the "Zero Reply Posts" listing when you came across this question, note that over on the right side of the screen, it shows what Forum the question is from.

Gerrit,
Are all these emails addresses in a single field, so you have multiple records with one field, or is it multiple fields within a single record?
If it is multiple records, do you want ALL the email addresses combined together, or will there be "groupings" based on another field?

 

[james_lankford]

Joe4,

Every email address is one record, so when I have 4 records I just need one string with 4 email address separated by a semicolon.
....

that's still confusing
4 records means 4 rows

so the question is "how many columns are in each row" --- or "how many fields are in each record"

but let's say you meant one record has 4 fields

the next question is
is it GUARANTEED that each field ALWAYS contains an email address ?

or is it possible that a field is blank or NULL ?

if its guaranteed then try

select 
  tbl.field_1 & '; ' & tbl.field_2 & '; ' & tbl.field_3 & '; ' & tbl.field_4 
from 
  tbl 
order by 
  tbl.field_1 & '; ' & tbl.field_2 & '; ' & tbl.field_3 & '; ' & tbl.field_4

 

[Joe4]

Every email address is one record, so when I have 4 records I just need one string with 4 email address separated by a semicolon.

Seems pretty clear to me...

I think this is going to require VBA code. Allen Browne wrote a UDF for something like this:
Microsoft Access tips: Concatenate values from related records
Microsoft Access Database: Concatenating multiple rows into single line in MS Access | Microsoft Access Database Tutorial - Learn How To Use Microsoft Access