By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,837 Members | 1,842 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,837 IT Pros & Developers. It's quick & easy.

Update/Append Query

P: 1
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
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,383
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.