Join a field two records

T

Tom Ventouris

Can the contents of the same field from two records be joined?
EG:
RecordID =1
MyTextField1 = "Work"
RecordID =2
MyTextField1 = "Place"
I want to return the text "WorkPlace"

I have not found anything by searching "Join" or "Merge" in A2007 Help.
 
O

Ofer Cohen

Is there a logic between the records you want to combine?
Is there a key field (AutoNumber) you can sort by, that gives you the right
order?

Do you want to join 2 to 1, 4 to 3, 6 to 5 .........
 
T

Tom Ventouris

Thanks gents. I am getting this (logical) response all too often for this
particular DB but once again data structure is not the issue. Here's what I
am doing:

A command button runs a query to export a selected ist of e mail addresses
to a txt file. The resulting file is a list of e mail addressess with a ";"
(part of the query.)

The txt.file is opened by the same command. The user then selects all/copies
and pastes the addressess into an E Mail form To: Field (we send mass mail
from INSIDE the DB). I thought it might be nice to have the query place the
addressess directly into the To: Field on our e mail form. (About 900
addresses at a time)

Linking to Outlook or similar is not an option.
 
R

Rick Brandt

Tom said:
Thanks gents. I am getting this (logical) response all too often for
this particular DB but once again data structure is not the issue.
Here's what I am doing:

A command button runs a query to export a selected ist of e mail
addresses to a txt file. The resulting file is a list of e mail
addressess with a ";" (part of the query.)

The txt.file is opened by the same command. The user then selects
all/copies and pastes the addressess into an E Mail form To: Field
(we send mass mail from INSIDE the DB). I thought it might be nice to
have the query place the addressess directly into the To: Field on
our e mail form. (About 900 addresses at a time)

Linking to Outlook or similar is not an option.
Click to expand...

If the data in the text file comes from a query then what is the text file even
needed for? Just loop through a Recordset based on your query concatenating all
of the email addresses into a string variable and then use that for the To
argument. How to do that is a very commonly asked and answered question in
these groups.
 
T

Tom Ventouris

Thanks, this is probably what I am looking for. I will search the group and
post back .
 
T

Tom Ventouris

I have found an example in Duane Hoekom's library that explains how I can get
the job done.
Thank you, and Mr Hoekom.
 
Top