Append Query Assistance

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
Click to expand...

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] & "*"
 
Back
Top