I was so hoping that I could figure this out on my own.... but alas, no such luck. So I turn to the maharishis of code....
I have two tabels: Tbl1, Tbl2
They each have a column containing emails
I want to compare each email in Tbl2 with the emails in Tbl1
If the email in Tbl2 is not present in Tbl1 then I want to add it to Tbl1
I'm working with Access07
As always, thank you for your help and guidance