[MS_AccessPros] Append only new records

 

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]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 3

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___