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
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
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.