Thread: Finding strings from 1 table in another table

Hello all - I'm going to start out with an apology for my general db and access ignorance. I've been kind of an excel enthusiast for the past year or so, but am now working with larger data sets that I've read are better handled by Access... so, figured I'd give it a shot.

If anybody here would be kind enough to give me a little bump to get me started, I'd appreciate it.

I have a database set up with two tables. Table 1 contains 4 columns of data and 900,000 records:
Table 1
A) Ticker symbol
B) Ticker official name
C) Ticker description
D) <<Blank>>

Table 2 is going to be about 500 records in two columns
A) Keyword
B) Keyword Category

What I need to do seems to be fairly simple, but I don't know where to start. My objective is to do the following
For each keyword in Table 2 (Column A: Keyword), search through Table 1 (Column B: Ticker Name). For every instance where the keyword is found, add the value from Table 2 (Column B: Keyword Category) to the record.

To illustrate, if my Keyword is "Exchange Rate" and the Keyword Category is "Fixed Income", then I want to sweep through the NAME column in table 1 and add "FIXED INCOME" to anything that has "Exchange Rate" anywhere in it's name.

Hope that makes sense... any guidance would be fantastic! And go easy on me, this is my first database!

Thanks...
JP

Would you clarify for me table 2? You have two fields with about 500 records. Are the 500 records unique? Are there are 500 different keywords? How many different keyword categories?

I am trying to determine if this can be achieved through an update query or if you need to loop through your recordset with some VBA to update your table.

Are you able to post your database without any proprietary data? Perhaps a scaled down version as there is a size limitation on posting.

Alan

JP;
There is no attachment posted.

What format is the file.... we can't download .mdb files...

Try zipping the file.. we accept .zip

I think you have to zip it first for access files.

If you continue to have a problem, click on the report icon in the upper right hand corner and advise the MODS.

Alan

Send a PM to our admin, RoyUk... to see why you can't include attachments.