using append query to add (overlapping data) to table

[wilkob]

I have made several extractions from back ups from our ERP system using maketable querys. Each time when I renamed the table after running the maketable query. I now want to add them to create one big table showing the records which I extracted. I now found that each time when I extracted from my back up tapes there was a little overlap in time which gives me double entries when I use an append query to add them al together.

Is there a way to set parameters which filter our double entries and only adds the unique records to this table?

 

[stopher]

Is there a way to set parameters which filter our double entries and only adds the unique records to this table?

If you identify a field (or fields) that will allow you to uniquely identify teach record then you can make that field the primary key (or index if you're not worried about a referential d/b). Then when you append, the duplicate records will be rejected (usually to an error table).
hth
Stopher