I am trying to create an append query if the record does not exist in the table. I have two table, Product_Details and a temp table. They contain basically the same information, with the exception of the temp table having minor updates. I am trying to see if there is a new record in the temp table, and if so, then append it to the Product_details.
Product_Details:
ID Name Qty Color Zip
12 Hammer 2 red 80976
13 nail 900 silver 76532
Temp:
ID Name Qty Color Zip
12 Hammer 2 Black 80976
13 nail 900 silver 76532
14 Glue 6 blue 23412
My current statement is through the access UI query:
Field: Name
Table: Temp
Sort:
Append To: Product_Details.Name
Criteria: [Temp].[ID] Not Like [Product_Details].[ID]
or:
This yields nothing. Any idea what I can do so that it will add the records that are not present in Product_Details?
Thank you!