470,647 Members | 1,328 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,647 developers. It's quick & easy.

Update/Append Query

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]
Jun 19 '07 #1
1 1688
Rabbit
12,516 Expert Mod 8TB
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:
Expand|Select|Wrap|Line Numbers
  1. Table: Term1
  2. DocID: XX001
  3.  
  4. Table: Term2
  5. DocID: XX001
  6.  
  7. Table: Master
  8. DocID: XX001
  9. KeywordField: Term1 Term2
  10.  
You'll have to run an update query for each table.

Expand|Select|Wrap|Line Numbers
  1. UPDATE Master INNER JOIN Term1 ON Master.DocID = Term1.DocID
  2. SET KeywordField = KeywordField & "Term1 "
  3.  
Then you rinse and repeat for each of your tables.
Jun 19 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

9 posts views Thread by Dom Boyce | last post: by
reply views Thread by warner | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.