Find and Replace against set of rules in 2nd table

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

  • Re: Find and Replace against set of rules in 2nd table
    ... UPDATE Tbl1 INNER JOIN Tbl2 ... >Jerry Straight ... (Would prefer an Update Query to update TBL1) ...
    (microsoft.public.access.queries)
  • Find and Replace against set of rules in 2nd table
    ... Not sure if this edited data can be written directly to the TBL1, ... be a query so that I can run it as needed. ... Prev by Date: ...
    (comp.databases.ms-access)
  • Re: deletions moved not deleted
    ... like RecID. ... You would do an Update query against tbl2 by identifying the tb1 record through it's ... Then run a Update query against tbl1 to delete the record with that same RecID. ...
    (microsoft.public.access.formscoding)
  • Re: Update data in table
    ... An update query would do the job here ... dim SQL as string ... > In tbl1 I have two fields. ... > update fldQty based on the result of the following function. ...
    (microsoft.public.access.formscoding)