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
Bookmarks