Append Query

[jrsarrat]

Hello! I hope this post finds you well.

I have created an Append Query to append information from one table to another. I wanted to run the same query and noticed that the query would the append all records vs. the added new records. How to I get this query to append only new records, and not duplicates?

 

[sheetspread]

Consider:

yes, union sounds right:

select MyField from MyTable1
union
select MyField from MyTable2
union
select MyField from MyTable3
union
select MyField from MyTable4

The above query can be used as the basis for a make table query or an append query if you want to store the results in a table. Note that Union will remove duplicates by default (if by duplicates you mean all the fields in each row - some people confuse this with duplicates in only one of the fields).

 

[jrsarrat]

Consider:

Thank you for your response. By duplicate, I'm referring to duplicate rows. I'm assuming that a union will always keep the desired fields selected. Am I correct?

Thank you!

 

[ranman256]

Build the append query,that uses the union query,
and set it to Unique values to remove dupes.

 

[xenou]

if you are still having trouble post the SQL for your append query.

 

[sheetspread]

I'm assuming that a union will always keep the desired fields selected. Am I correct?

If by selected you mean part of the query then yes.