Simple Append Query Help

[grkatz823]

I have a simple append query set up that will take rows of material from one table (called Material Form Entry) and places it into another table(called All Materials). However, there is some overlap between the tables, and in those cases I need to ignore the append order



What is the criteria I should set to check every row in All Materials to make sure that there will be no duplication and these overlapping rows can be ignored? Thanks.

[JoeM]

Perform an unmatched query between your two tables, so that is only returns the unmatched records (there is a Query Wizard for that).
Then, turn that query into your Append Query.