Append Query Assistance

[Guest]

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?

Thanks,
Hank

 

[Jeff Boyce]

"Partial match"...

Do you consider the following to be a partial match:

J. J. Johnson
1234 Elm St
Somewhere, US

John Jacob Johanson
1243 Elm Ave
Somewhere, USA

John Johnson, Jr.
1234 Elm St SW
Somewhere, US

Now, how are you going to tell Access to "understand" that these are "close
enough"? How would you tell a paid office worker (hint: this would be much
easier)?

Can you describe "why" you are trying to do this? There may be another
approach that solves your situation.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Guest]

TBL2, COL1 would have Johnson

So all records with Johnson would be moved to TBL3.

 

[Jeff Boyce]

You've described what, not why. Why do you feel it is necessary to move
Johnson records from one table to another?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Guest]

Simply put, I want to further scrutinize these particular records. Looking
for similaries in orders, or similarities in types of items purchased.

 

[Jeff Boyce]

Rather than move records around, could you also accomplish what you want by
using a query to isolate the records of interest? That way, you wouldn't
have to create a new table, move copies of records, work out the issues of
synchronization between the copies, ...

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/