I have two tables and am running a query to append the results of a query into new third table, however if I run the query again I dont want to append duplicate records into the new table. Any advise please.
1. set up a link from the source and destination tables and specify criteria based on null values in the destination that excludes records already present. set the link to include all records from the source.
2. Ensure your keyed fields don't allow duplicate records. When you run the append it will give you an error and put any duplicates into a "paste errors" table if I'm not mistaken. If you run this via code you can use setwarnings to turn off this error message and delete the paste errors if you like.
In option 1 there is a link between the tables already, (PropertyID and RequirementID) could you explain a little more about specifying null values in the destination that exludes records already present (Is there an SQL statement for this) Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.