extract records using list of "keywords"...

[zestygirl]

Here's one I cannot get my head around.

I have a list of order numbers to follow up.

I want to pull related email records to the list of order numbers.

Each email record consists of a long field of text, where the order number may or may not be.

Therefore: I want a query that will display related emails next to each order number.

Does this make sense?

The reason I'm at a standstill is because I cannot find a way to relate the two tables initially because there is not a "link".

Ideally, I wouldl like to "extract" any po numbers from the email records and create a new field that displays the extracted po number (the addition of this field would form the basis for any future "links").

Vaguely, a vlookup comes to mind but.....there may be multiple email records for each order number, so it would have to be able to return all relevent records.

Any help is appreciated and will save me a millenium of digging through 10,000 emails for instances of about 600 order numbers.

 

[Steve R.]

Use the LIKE command in a query.

Like "*" & [Forms]![FindProjectNumberfrm]![Text1] & "*"

The code above shows all records that have a certain project number. Text1 is where you enter the project number. The results are then displayed on a subform in datasheet view..

 

[zestygirl]

Thanks, Steve! Worked like a charm!



(gratefully clapping my hands & smiling).

Boss is gonna think I'm a genius. Nice.