Open Recordset Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'.. SELECT COUNT(*) AS NoResults FROM tblXML WITH (NOLOCK) INNER JOIN tbl807C39564AEC41EA8D732264543C6A4D WITH (NOLOCK) ON tbl807C39564AEC41EA8D732264543C6A4D.RecordID = tblXML.ID AND tbl807C39564AEC41EA8D732264543C6A4D.fldF8E18C642B4D44608AEBC2F6BB8DDD6D = '{985C287C-418A-4063-88A8-3C3F0D84C681}' WHERE tblXML.fld1453BEEFA8D64F4CB4285850C8CA2540 IN ('{9AF92E07-CC58-4AC0-8F56-2EAB376953CD}',) AND tblXML.Approved = 1
