Update/Append Query

[rebexter]

I have a list of about 58,000 records which I created by merging numerous smaller lists, each of which contain a certain keyword.

What I want to do now is update the master list of 58,000 records so that each line shows which of one or more keywords that record contains.

For example, the original source tables contain the following fields:

DocID, Keyword

where DocID uniquely identifies each record no matter what table that record is in.

If Term1 table contains DocID XX0001 and Term2 table also contains DocID XX0001, in the master table (All) that was created by merging tables Term1 and Term2, I want to create a field (Issues) which will contain the text Term1, Term2, which is created by pulling and linking data from the two individual term tables.

I'm not sure if I'm explaining this well. I don't know SQL, but I've been able to figure out the user-interface query system in Access somewhat. I've figured out how to update records, but now I would like to update and append subsequent series of data.

Any suggestions or advice?

Rebecca Schley
[E-Mail Deleted]

[Rabbit]

I have a list of about 58,000 records which I created by merging numerous smaller lists, each of which contain a certain keyword.

What I want to do now is update the master list of 58,000 records so that each line shows which of one or more keywords that record contains.

For example, the original source tables contain the following fields:

DocID, Keyword

where DocID uniquely identifies each record no matter what table that record is in.

If Term1 table contains DocID XX0001 and Term2 table also contains DocID XX0001, in the master table (All) that was created by merging tables Term1 and Term2, I want to create a field (Issues) which will contain the text Term1, Term2, which is created by pulling and linking data from the two individual term tables.

I'm not sure if I'm explaining this well. I don't know SQL, but I've been able to figure out the user-interface query system in Access somewhat. I've figured out how to update records, but now I would like to update and append subsequent series of data.

Any suggestions or advice?

Rebecca Schley
[E-Mail Deleted]

If I understand correctly:

Table: Term1
DocID: XX001
 
Table: Term2
DocID: XX001
 
Table: Master
DocID: XX001
KeywordField: Term1 Term2
 

You'll have to run an update query for each table.

UPDATE Master INNER JOIN Term1 ON Master.DocID = Term1.DocID
SET KeywordField = KeywordField & "Term1 "
 

Then you rinse and repeat for each of your tables.