Append Query Assistance

[Guest]

My CSRs are each responsible for reviewing their section of the alphabet
looking for similarities. To assist them,
I need an Append Query that looks something like this:

TBL1, COL1
If TBL2, COL1 has a partial match to TBL1, COL1
Then Move TBL1, Entire Record to TBL3

All Three TBLs already exist, as do the TBL Structures and there
is no relationship between the TBLs.

Can someone please assist me with the correct SQL syntax?

TBL2, COL1 has precise information I'm looking for, such as Johnson.

Thanks,
Hank

 

[KARL DEWEY]

You have conflicting statements -

If TBL2, COL1 has a partial match to TBL1, COL1
TBL2, COL1 has precise information I'm looking for, such as Johnson.

Does contain "Johnson" only and you are looking for a match withing a string
in TBL1, COL1?
If this is the case then create your append query and use this as criteria
for TBL1, COL1.
Like "*" & [TBL2].[COL1] & "*"