Hi
I put your query into text editor and designed it there, so syntax problems are more visible, and added comments on faulty syntax, preceeded with --.
sql14=
"INSERT INTO tblTC_1_2_report_detail
(
tc12reportID,
[Labjob],
[Sample],
sampleID], -- missing [
[OriginalAnalyst],
[QCAnalyst],
[atID],
[OriType],
[QCType],
[OriCount],
[QCCount],
[QCID],
[ID_Criteria],
[Major_Criteria],
[Minor_Criteria],
[Void], [Void_Comment],
[Criteria_Status]
 
SELECT
" & a & ",
'" & rs("Labjob") & "',
'" rs("sample") & "', -- '" & rs("sample") & "',
" & rs("sampleID") & ",
" & rs("OriginalAnalyst") & ",
'" & rs("QCAnalyst") & "',
" & rs("AnalysisID") & ",
'" & rs("OriType") & "',
'" & rs("QCType") & "',
" & rs("OriCount") & ",
" & rs("QCCount") & ",
" & rs("QCID") & ",
" & rs("ID_Criteria") & ",
" & rs("Major_Criteria") & ",
" & rs("Minor_Criteria") & ",
" & rs("void") & ",
'" & rs("void_comment") & "',
'" & rs("criteria_status") & "';" -- OK scrap the rest! I forgot you use recordset here. I'm not sure about recordset query syntax at moment, I seldom use it. -- remove semicolon, as you cant stop query string here.
-- Scrap it! -- FROM ...
--Scrap it! The main problem - your query string is unfinished. You can't use SELECT without FROM! And there are minor syntax errors for good measure too!