And may not be Access compatible (i.e. alias for the table names):

SELECT \n   sch.Level, \n   sch.Job, \n   sch.Schid, \n   sch.System, \n   trg.StartTm, \n   sch.TriggerBy, \n   sch.NOEX, \n   cmj.Comm INTO [Q-Day13 Schedule]\nFROM [Trigger Jobs] trg\n   INNER JOIN (Schedule sch LEFT JOIN CommJobs cmj ON sch.Job = cmj.Job) ON trg.Link = sch.Link\nWHERE \n   (\n      (trg.BusinessFunction = [qSystem]) AND\n      (trg.RunDays = [qDOM]) AND \n      (trg.Calendar = "SP") AND\n      (trg.Months = "ALL" OR trg.Months Like [qMonth])\n   ) OR (\n      (trg.BusinessFunction = [qSystem]) AND \n      (trg.RunDays Like [qAPDay]) AND \n      (trg.Calendar IN("AP", "DY")) AND \n      (trg.Months = "ALL" OR trg.Months Like [qMonth]) AND \n      (trg.Frequency = "M")\n   ) OR (\n      (trg.BusinessFunction = [qSystem]) AND \n      (trg.RunDays Is Null) AND \n      (trg.Calendar IN("AP", "DY")) AND \n      (trg.Frequency = "D")\n   ) OR (\n      (trg.BusinessFunction = [qSystem]) AND \n      (trg.RunDays Not Like [qAPDay]) AND \n      (trg.Calendar IN("AP", "DY")) AND \n      (trg.Frequency = "D")\n   ) OR (\n      (trg.BusinessFunction = [qSystem]) AND \n      (trg.RunDays Like [qDOW] And trg.RunDays Not Like [qExcept]) AND \n      (trg.Calendar IN("AP", "DY")) AND \n      (trg.Frequency = "W")\n   ) OR (\n      (trg.BusinessFunction = [qSystem]) AND\n      (trg.RunDays Like [qJDate]) AND \n      (trg.Calendar = "JU")\n   )\nORDER BY trg.StartTm, sch.Key;