I'm trying to do a search by using the Access query(not vba) to serach for all records that is not in a another database but was unsuccessful with it. I have try the vba way but the filter and find method to search for social security number is too slow. if it was a string, it can search for it quickly (I dont know why though, i'm curious about it) Anyways, here is what i'm doing now. The MinUnitData table is the new data and I want to scan the mwpat table to see if the "PatientID" is in the mwpat.social security number table.
I have try the not and not like, and it didn't work for me
FROM MinUnitData INNER JOIN mwpat ON MinUnitData.PatientID = mwpat.[Social Security Number]
WHERE ((Not (MinUnitData.PatientID)=[mwpat].[social security number]));
It took me a while to find the "Find Unmatched" query. You have to click on the NEW button actually.
Thanks it worked but I dont understand how it works though. I'm seeing there is an relationship arrow pointing to mwpat table? What is it? Also, why is the mwpat.social security number criteria set to Null.