Experts, I have the below APPEND query.
I am trying to APPEND to tblConsortium where tblAgreements_thisPrj.AgtI
D is NOT IN tblConsortium.AgtID
There are records that should be APPENDED but when I run it there are 0 records to be APPENDED.
What do you think is missing?
thanks.
INSERT INTO tblConsortium ( AgtID )
SELECT tblAgreements_thisPrj.AgtI
D
FROM tblAgreements_thisPrj
WHERE (((tblAgreements_thisPrj.A
gtID) Not In (SELECT [tblConsortium].[AgtID] FROM [tblConsortium])));
Open in new window
HTH,
Kent