SELECT *
FROM tbljob INNER JOIN (tblemploye INNER JOIN tblqm ON tblemploye.IDEmploye = tblqm.IDEmploye) ON tbljob.IDJob = tblqm.IDJob WHERE Date BETWEEN #Date1# AND BETWEEN #Date2# ORDER BY Date

Nom Prenom Lundi Mardi Mercredi Jeudi Vendredi Samedi Dimanche

Requete = "SELECT *
FROM tbljob INNER JOIN (tblemploye INNER JOIN tblqm ON tblemploye.IDEmploye = tblqm.IDEmploye) ON tbljob.IDJob = tblqm.IDJob WHERE Date BETWEEN #Date1# AND BETWEEN #Date2# ORDER BY Date"
       
rs.Open Requete, Cnn, adOpenStatic, adLockOptimistic
       
        Set RapportSemaineQM.DataSource = rs
        RapportSemaineQM.Sections("Section4").Controls("Label1").Caption = "Planification des taches pour la semaine du " & DatePer(0)
        RapportSemaineQM.Sections("Section1").Controls("txtLundi").DataField = "NomJob"
        RapportSemaineQM.Sections("Section1").Controls("txtMardi").DataField = "NomJob"
        RapportSemaineQM.Sections("Section1").Controls("txtMercredi").DataField = "NomJob"
        RapportSemaineQM.Sections("Section1").Controls("txtJeudi").DataField = "NomJob"
        RapportSemaineQM.Sections("Section1").Controls("txtVendredi").DataField = "NomJob"
        RapportSemaineQM.Sections("Section1").Controls("txtSamedi").DataField = "NomJob"
        RapportSemaineQM.Sections("Section1").Controls("txtDimanche").DataField = "NomJob"

RapportSemaineQM.Show

SELECT tbljob.NomJob AS NomJob, tbljob_1.NomJob AS NomJob1, tbljob_2.NomJob AS NomJob2, tbljob_3.NomJob AS NomJob3, tbljob_4.NomJob AS NomJob4, tbljob_5.NomJob AS NomJob5, tbljob_6.NomJob AS NomJob6, tblemploye.Nom, tblemploye.Prenom  FROM tblutilisateurs INNER JOIN (((tblqm AS tblqm_4 INNER JOIN tbljob AS tbljob_4 ON tblqm_4.IDJob = tbljob_4.IDJob) INNER JOIN ((tblqm AS tblqm_5 INNER JOIN tbljob AS tbljob_5 ON tblqm_5.IDJob = tbljob_5.IDJob) INNER JOIN ((tbljob AS tbljob_6 INNER JOIN tblqm AS tblqm_6 ON tbljob_6.IDJob = tblqm_6.IDJob) INNER JOIN ((tbljob AS tbljob_3 INNER JOIN tblqm AS tblqm_3 ON tbljob_3.IDJob = tblqm_3.IDJob) INNER JOIN ((tbljob AS tbljob_2 INNER JOIN tblqm AS tblqm_2 ON tbljob_2.IDJob = tblqm_2.IDJob) INNER JOIN ((tblqm AS tblqm_1 INNER JOIN tbljob AS tbljob_1 ON tblqm_1.IDJob = tbljob_1.IDJob) INNER JOIN ((tblemploye INNER JOIN tblqm ON tblemploye.IDEmploye = tblqm.IDEmploye) INNER JOIN tbljob ON tblqm.IDJob = tbljob.IDJob) ON tblqm_1.IDEmploye = tblemploye.IDEmploye) ON tblqm_2.IDEmploye = tblemploye.IDEmploye) ON tblqm_3.IDEmploye = tblemploye.IDEmploye) ON tblqm_6.IDEmploye = tblemploye.IDEmploye) ON tblqm_5.IDEmploye = tblemploye.IDEmploye) ON tblqm_4.IDEmploye = tblemploye.IDEmploye) INNER JOIN tblstatus ON tblemploye.IDStatus = tblstatus.ID) ON tblutilisateurs.ID = tblemploye.IDSuperviseur WHERE (((tblqm.Date)=#" & DateTemp & "#) AND ((tblqm_1.Date)=#" & DateTemp1 & "#) AND ((tblqm_2.Date)=#" & DateTemp2 & "#) AND ((tblqm_3.Date)=#" & DateTemp3 & "#) AND ((tblqm_4.Date)=#" & DateTemp4 & "#) AND ((tblqm_5.Date)=#" & DateTemp5 & "#) AND ((tblqm_6.Date)=#" & DateTemp6 & "#) AND ((tblstatus.[Actif])=1) AND ((tblutilisateurs.ID)=" & IDLog & "))"