INSERT INTO TEACHER_TEST_LINKED_TBL ( SAMPLE_ID_NUMERIC, SAMPLECODE, DATETAKEN, GRADECODE, FACILITYCODE, COMMENTS, SAMPLE_WA_TANK_NUMBER, SAMPLE_A_TRIP_ID, SAMPLE_DESCRIPTION )

(SELECT STUDENT_TEST.SAMPLE_ID_NUMERIC, STUDENT_TEST.SAMPLECODE, STUDENT_TEST.DATETAKEN, STUDENT_TEST.GRADECODE, [UNIVERSITY_FACILITY LOCAL].FACILITYCODE, "Sample tested " AS Comments, STUDENT_TEST.TANK, STUDENT_TEST.SAMPLE_A_TRIP_ID, [STUDENT_TEST]![GRADECODE]+" "+"ELIGIBLE" AS Sample_Description

FROM ((STUDENT_TEST INNER JOIN [EmployeeTbl] ON STUDENT_TEST.Terminal = [EmployeeTbl].CityST) INNER JOIN [UNIVERSITY_FACILITY LOCAL] ON [EmployeeTbl].FACILITYCODE = [UNIVERSITY_FACILITY LOCAL].FACILITYCODE) LEFT JOIN [TEACHER_TEST_LINKED_TBL LOCAL] ON STUDENT_TEST.SAMPLECODE = [TEACHER_TEST_LINKED_TBL LOCAL].SAMPLECODE

WHERE ((([TEACHER_TEST_LINKED_TBL LOCAL].SAMPLECODE) IS NULL))

ORDER BY STUDENT_TEST.SAMPLECODE)

ON CONFLICT ON CONSTRAINT myconstraint DO NOTHING;