Append Records without Duplicates

[Jaimeta]

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

 

[PieterLinden via AccessMonster.com]

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

So you only want to add the new (different) records to the existing ones?
Use the FindUnmatched query wizard and then turn that into an append query.