Append Records without Duplicates

Jaimeta

Guest

Posts: n/a

25th May 2010

I have a table with several columns. Twice a day, I need to add (backup) the
records to another table. But I don't want duplicates. So I have to have a
module that looks at the last Date and End Time so I don't get duplicates in
my new table.

Any help would be great!

Index Date End Time
1 1100520 211008
2 1100520 211029
3 1100520 211031
4 1100521 211031
5 1100521 211031
6 1100522 211046
7 1100522 211046
8 1100522 211046
9 1100522 211054

« Utilizing Recordset field in vb Requery Command Verbiage | Append 2 tables with variable names »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Append Query - key violation - no duplicates, records exist in par	Tammy	Microsoft Access Queries	4	6th Aug 2009 01:49 PM
Main Switchboard can't append all the records in the append query	=?Utf-8?B?U2hlbGw=?=	Microsoft Access	0	2nd Jul 2007 11:34 AM
Append query duplicates records	Jason Morin	Microsoft Access Queries	4	17th Mar 2005 12:45 AM
Append new records but don't create duplicates	=?Utf-8?B?Q29tcHUgR2Vlaw==?=	Microsoft Access Queries	4	6th Jul 2004 10:13 AM
APPEND Query Duplicates Records rather than Adding New	Angela Corvaia	Microsoft Access Queries	3	22nd Oct 2003 09:24 PM