Find both matched and unmatched entries

[GLT]

Hi,

I have two tables that I wish to find:

1) find matched data - copy that into a separate table
2) find unmatched data - copy that data into a separate table

Can I achieve the above results with one query?

I have three fields in each table that I would like to compare against:

Client
Data
Status

Any assistance with this would be greatly appreciated...

Cheers,
GLT

 

[Wayne-I-M]

Hi

Yes you can use an append query to do this quite simple BUT you would end up
with the same data in 2 tables which be a mistake.

Maybe you could post some more details of what you are trying to do (the end
result) and maybe someone could suggest another method. It "may" be that you
really should have the tables split into 2 new tables and then delete the
original or someone could offer another method.