since it says "Number of query values and destination fields ", let's check the Number of query values and destination fields :
Code:
INSERT INTO KeepThese (
f_fullName,addresses, cities, us_states_and_canada, zip_code,Ex_fullName)
SELECT
f.aname, f.addresses,f.cities,f.us_states_and_canad a,f.zip_code
FROM PrepareForDuplicateCheck2 AS f
LEFT JOIN (SELECT t.aname,t.addresses,t.cities,t.us_states_and_canad a,t.zip_code FROM PrepareForDuplicateCheck2 AS t GROUP BY t.aname HAVING Count(t.aname)>=6) AS Ex ON f.aname=Ex.aname
WHERE Ex.aname Is Null;
What is the pink a? and the red Ex_fullname has no corresponding select field.