Join a field two records

[Guest]

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.

 

[Rick Brandt]

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.

And if you also have RecordID values 3, 4, 5, 6...5000 then what should happen
to all of those?

Generally speaking the need to do something like this suggests that your table
design is incorrect (that is why you see nothing about this in help).

 

[Guest]

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 .........

 

[Guest]

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.

 

[Rick Brandt]

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.

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.

 

[Guest]

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

 

[Guest]

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