RE: [MS_AccessPros] How do I append only 'new' records.

Robin,

I suggest using the un-matched query wizard to find records from one table that are not in the other. Use this query as the source for an append query.

If you can't figure this out, come back with both table names as well as the fields that make them unique.

Duane Hookom

MS Access MVP

________________________________
> To: MS_Access_Professionals@yahoogroups.com
> From: robinski@mymail.net.au
> Date: Sat, 26 Nov 2011 16:35:55 +1100
> Subject: RE: [MS_AccessPros] How do I append only 'new' records.
>
>
>
> My apology that I failed to express myself clearly.
>
> At 26/11/2011 04:03 PM, you wrote:
> >How would you do this manually?
>
> I would need to view each entry in 18,000 records and look for the
> same entry in the second set of 30,000 records.
>
> >How do you define "duplicates"?
>
> Where and existing record is "1" "2410" "87" "24"
>
> and the same record set is in the second set of data.
>
> Regards,
>
> Robin Chapple
>
> >Duane Hookom
> >MS Access MVP
> >
> >To:
> MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals%40yahoogroups.com>
> >From: robinski@mymail.net.au<mailto:robinski%40mymail.net.au>
> >Date: Sat, 26 Nov 2011 15:34:28 +1100
> >Subject: [MS_AccessPros] How do I append only 'new' records.
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > My group have been building historic records by manually entering
> >
> >data from several sources.
> >
> >We now have 30,000 records of posts held by members back to 1921,
> >
> >very thin for the early years.
> >
> >
> >
> >Each record is four numeric fields. The SQL is:
> >
> >
> >
> >SELECT tClubPostHolders.tblClubPostHoldersID,
> >
> >tClubPostHolders.ClubPostID, tClubPostHolders.MemberID,
> >
> >tClubPostHolders.YearID, tClubPostHolders.ClubID
> >
> >FROM tClubPostHolders;
> >
> >
> >
> >I now have 18,000 records from another source which I plan to append
> >
> >to the existing table. How do I avoid duplicates?
> >
> >
> >
> >Many thanks,
> >
> >
> >
> >Robin Chapple
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >[Non-text portions of this message have been removed]
> >
> >
> >
> >------------------------------------
> >
> >Yahoo! Groups Links
> >
> >
> >
>
>
>

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/