INSERT INTO tblListOfProblemSpots ( O_PositionFeet, O_Text, O_Level, TIOS_ID, TIOSat_ID, TimesMailed, O_OpCode, Regional_Engineer, Maintenance, ResponseCombo, Category, Obs_ID )
SELECT O_T.O_PositionFeet, O_T.O_Text, O_T.O_Level, O_T.S_ID, O_T.Sat_ID, 0 AS TimesMailed, O_T.O_OpCode, tblExtraNotifications.Regional_Engineer, tblExtraNotifications.Maintenance, qry_UnionResponsible.COMBO2, qry_UnionResponsible.Catagory, O_T.O_TID
FROM (tblExtraNotifications LEFT JOIN O_T ON tblExtraNotifications.OpCode = O_T.O_OpCode) LEFT JOIN qry_UnionResponsible ON tblExtraNotifications.OpCode = qry_UnionResponsible.OL.OpCode
WHERE (((O_T.S_ID)>="AR*") AND ((O_T.O_OpCode) Is Not Null) AND ((O_T.O_Value1)>=[tblExtraNotifications].[Notify]))
ORDER BY O_T.Sat_ID;