[MS_AccessPros] Re: Append only new records

 

Hi,
Why have two tables with basically the same data?
Why not just have a True/False field called NewVoter?
Abraham

--- 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]
>

__._,_.___

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

Messages in this topic (3)

Recent Activity:

• New Members 2

Visit Your Group

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

.

__,_._,___