Automatic duplicate deletion after appending to table

[ltcarlisle]

I have a table with data and I'm going to be appending another similar table every week. I'd like to run a query that eliminates all duplicate entries in the new, larger table automatically. Is this possible?



Thanks

[burrina]

Can you not filter out duplicate values beforehand?

[June7]

Bing: Access delete duplicate records same table

http://office.microsoft.com/en-us/ac...#_Toc257848396

[orange]

You could put a unique index (possibly composite) to reject duplicates as an entry attempt is made.
Why are there duplicates?