Re: Find and Replace against set of rules in 2nd table
- From: "Larry Linson" <bouncer@xxxxxxxxxxxxx>
- Date: Sat, 31 Dec 2005 06:24:43 GMT
"Hank Rouse" <hank_top_sf@xxxxxxxxxxx> wrote
> Looking for a tool, or code that does the following.
Unlikely there's a "tool" that meets your specific requirements. It's quite
possible that code or a query could be developed to do it -- depending on
the details.
> Edit [partial field data] in TBL1, if [partial field data] meets criteria
in
> TBL2, COL1. TBL2, COL2 has the REPLACE WITH information.
Can you be specific about "meets the criteria" in TBL2, COL1? And, er, what
do you mean by "[partial field data]"?
> Not sure if this edited data can be written directly to the TBL1, or
needs
> to write to a TEMP TBL.
Are TBL1 and TBL2 related by a key/foreign key, or do you intend that TBL2
is a table of instructions for updating each Record of TBL1?
> As I will continue to be tweaking and TBL COL1 & COL2, I would like this
to
> be a query so that I can run it as needed.
Larry Linson
Microsoft Access MVP
.
- Follow-Ups:
- Re: Find and Replace against set of rules in 2nd table
- From: Hank Rouse
- Re: Find and Replace against set of rules in 2nd table
- References:
- Find and Replace against set of rules in 2nd table
- From: Hank Rouse
- Find and Replace against set of rules in 2nd table
- Prev by Date: Re: reset number on new year
- Next by Date: Re: =Iff(([Me]![Gender])="M","Male","Female")
- Previous by thread: Find and Replace against set of rules in 2nd table
- Next by thread: Re: Find and Replace against set of rules in 2nd table
- Index(es):
Relevant Pages
|
|
