Add stock numbers from one table to another if the stock number doesn't already exist

[Vodi]

Good day,

I have a table, tbl_RYG, that gets imported monthly. The indexed field in this table is a stock number (PNSN). I have another table, tbl_Tracker_Notes, that I would like to contain all of the stock numbers that have ever been imported. It contains different fields that data is input into through a form.

Is there a qry, code, or method that will look at the stock numbers from the import (tbl_RYG) and compare them to the tbl_Tracker_Notes, and will add new ones from tbl_RYG into tbl_Tracker_Notes?

Your time and assistance are much appreciated.

[jwhite]

The following is an example how to do this:

INSERT INTO TableB (Item Number)
SELECT TableA.Item Number
FROM TableA
WHERE TableA.ItemNumber NOT IN (SELECT ItemNumber FROM TableB);

Modify to suit your table/field names and columns.

[Vodi]

Thanks, jwhite. Where would I place that code?

[CJ_London]

use a left join to identify missing records - something like

INSERT INTO tblTrackerNotes (fld1, fld2)
SELECT tblRYG.fld1, tblRYG.fld2 
FROM tblRYG LEFT JOIN tblTrackerNotes ON tblRYG.ID=tblTrackerNotes.ID
WHERE tblTrackerNotes.ID is Null

And given your last post - open a new query, go to the sql window and paste the code, then correct names to your actual names

[jwhite]

You can create a New Query, modify it as desired and save it, perhaps named qryTrackImportedStockNumbers