Re: Find and Replace against set of rules in 2nd table

TBL1

COL1
Mari Johnson
Jim Evans
Charles Stanley
Jerry Straight

TBL2

COL1 COL2
Mari Mary
Straight Strait

See, I'm simply searching TBL1, COL1 for any match in TBL2, COL1.
If a match is found, Bad data in TBL1, COL1 is replaced by TBL2, COL2


"Hank Rouse" <hank_top_sf@xxxxxxxxxxx> wrote in message
news:Uwltf.40364$7h7.21701@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Looking for a tool, or code that does the following.
>
> Edit [partial field data] in TBL1, if [partial field data] meets criteria
in
> TBL2, COL1. TBL2, COL2 has the REPLACE WITH information.
>
> Not sure if this edited data can be written directly to the TBL1, or needs
> to write to a TEMP TBL. (Would prefer an Update Query to update TBL1)
>
> As I will continue to be tweaking and TBL2 COL1 & COL2, I would like this
to
> be a query so that I can run it as needed.
>
> Thanks in Advance
>
>


.

Relevant Pages