How do I stop duplicate entries in a table from an append query?

[shabbaranks]

Hi,

How do I get my append query working so it doesnt append duplicates onto an existing table? Currently if I run the append query I get multiples of the same data?



Thanks

[jzwp11]

You will have to create a query that finds the unique records in the first table (the unmatched query wizard should help with that) and then use that query as the basis for your append query.