Query help needed

[Straw]

I have table A and table B which have a field in common called Clients.

I want to find all the Clients in table A that do not exist in table B and add them to table B. What is the easiest way to do this. I am sure it is a simple query?

Thanks!

 

[Maquis]

Use the "Find unmatched" query wizard. It provides step by step instructions for setting up this type of query. When you're done, you can either turn this query into an append query or create a 2nd query based on the 1st query to append the records. Maq B-)
<insert witty signature here>