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;