I have a query that imports one table into another. It duplicates the records from time to time but without any reason. What are some of the reasons why it could be doing this and can I get by without writting a query to find and delete the duplicates?

If your append query contains a join, that would cause duplicates when the tables have a 1-to-many relationship. You could try the effect of adding the DISTINCT keyword to the select portion of the append query. Also, it sounds like the table you are appending to does not have a unique primary key defined.

Hello,
If I append one table's field to the primary key of another table with data on it already and no duplicates, it should just update the the new information right? it will not duplicated? right?
Let me know