James
You can do it by joining the tables on what makes a record unique. Maybe the first name, middle initial, last name and address. Make the joins to show all records in the new table and only matching records in the main table.
On the criteria line, put Is Null for all the unique fields in the main table. That should append only new records.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
--- In MS_Access_Professionals@yahoogroups.com, James McAlister <forums01@...> wrote:
>
> I have a main data table of existing voters (Registrations) and another
> table of new voter registrations (NewRegistrations). Since some of the
> records in NewRegistrations already exist in Registrations (so they are not
> actually new voters), I would like to append only the actual new voters in
> NewRegistrations to Registrations and ignore the others.
>
> How would I set up my query to do this? Primary key in both tables is
> VoterID.
>
> thanks!!
>
> James
> www.james-mc.com
> Words To Live By
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar