I am getting ready to import our 2013 PayPal data into our MS Access donor tracking database so I can send out annual receipts. About two dozen of the 2,100+ records have already been entered manually by me because the donation was for $250 or more, it was a first-time donation, the donor requested a receipt right away, etc. The query works, but now I want it to NOT append the data record if the PayPal Transaction ID (a unique alphanumeric string) is already present in the donations table. Here is what the query looks like:
. So what do I put in the criteria box in the Transaction ID column so that the record is ONLY appended if [1PayPalDataToImport].[Tra
tID]? The text of the query is attached. Or am I going about this all wrong?