Combining 2 fields in a query

  • Thread starter Thread starter Joe Donohue
  • Start date Start date
J

Joe Donohue

This may be a very basic question but I have not been
able to figure out how to do it.

I need to combine 2 fields from a table into one in a
query.

For example, each record contains two email fields and I
need to combine them into one field with a comma
separating them. The output should look like this:
(e-mail address removed), (e-mail address removed).

The intent is to use the combined field in a mail merge
document to email. This would have the effect of having
a "To:" and a "cc:" field on the email merge.

Thanks in advance.
 
Thank you Les. I'll try that.
Joe
-----Original Message-----
Create a new field in your query something like:

Newfld:[field1] & ", " & [field2]
-----Original Message-----
This may be a very basic question but I have not been
able to figure out how to do it.

I need to combine 2 fields from a table into one in a
query.

For example, each record contains two email fields and I
need to combine them into one field with a comma
separating them. The output should look like this:
(e-mail address removed), (e-mail address removed).

The intent is to use the combined field in a mail merge
document to email. This would have the effect of having
a "To:" and a "cc:" field on the email merge.

Thanks in advance.

.
Click to expand...
.
Click to expand...
 
Back
Top