Append Query, Don't Duplicate Values

[conleyle]

I'm running a make table query followed by an append query.

Is there a way to do the append query that if the item already exists, it won't add a new line?

Let me know if that doesn't make sense.

 

[Joe4]

Do an unmatched query between the table you are writing to and the table you are writing from (so that it only returns records that are no already found in your destination table). Then use this query as the basis for your append query.

 

[conleyle]

Thanks. That is a lot less steps than what I was going to do.