Yup, that did it...




Code:
SELECT DISTINCT qryRawData.VendID, qryRawData.VendNameFROM qryRawData LEFT JOIN tblVendor ON qryRawData.[VendID] = tblVendor.[VendID]
WHERE (((tblVendor.VendID) Is Null));
does exactly what I need it to... thanks!

It still takes about 30-45 seconds to run, which makes me question that I have everything set up as efficiently as possible... but at least it's outputting correctly and not crashing...

Next up... fix the import to go to a static table (I do realize I'll have to update the query definitions to the new table)

So we'll call these tmptblData and tmptblOTD... I'm gonna try what I posted in post #4 for import... if that doesn't work, gonna be stuck again...

I'll be on a google spree after that searching for VBA to run append qryRawData, run append qryVender, send error prompt if there is a problem, then clear the table, and Msgbox confirm operation complete... I'm sure I'll collect all that eventually and do some minor syntax error that makes it not work, then be back here... so if anybody wants to save me some googling and frustration, then kudos... I imagine the error check will be the PITA... but I definitely need to know if there was a problem updating the tables

BTW... Thank you for your help so far, June7! I tend to get "close" to where I want to go, then paint myself into a corner with some syntax issue that I don't have eyes to recognize


UPDATE: Post #4 worked for the import... so, moving on to the VBA to run the queries, error check, clear table, and msgbox

Pretty sure I'll be fine except for the error check... but I feel like with such big data pulls it would be irresponsible to not have an error check