Identify records that are on 1 table but not another

[AccNovice]

I am trying to identify the records that are on Table1 but not on Table2.
After I have identified these records I want to update Table2 with these records.

My questions (and please feel free to laugh at my ignorance) are:

1. What query type do I need to use to identify the records on Table1
and how should the SQL look like?
2. What query type do I use to then update these records in Table2?

Any help will be much appreciated

 

[maxmangion]

Hi

For the first try the Unmatched Query Wizard. For the second you can try the append query.

 

[AccNovice]

Thanks you so much - your advice where spot on!

 

[maxmangion]

you're welcome