SQL = " SELECT Rapport_tmp.No_Historique, Rapport_tmp.Hr_debut_reel, Rapport_tmp.Hr_fin, Rapport_tmp.Nb_hres, R_Internet_missions_exceptionnelles.hres_de_jour, R_Internet_missions_exceptionnelles.hres_de_nuit, R_Internet_missions_exceptionnelles.hres_nuit_payees, R_Internet_missions_exceptionnelles.nuit, R_Internet_missions_exceptionnelles.prime_apv_leader, R_Internet_missions_exceptionnelles.ce, Rapport_tmp.commentaires"
'SQL = SQL & " FROM Rapport_tmp INNER JOIN R_Internet_missions_exceptionnelles ON (Rapport_tmp.No_operation = R_Internet_missions_exceptionnelles.No_Operation) AND (Rapport_tmp.No_Historique = R_Internet_missions_exceptionnelles.No_Historique) AND (Rapport_tmp.dt_HE = R_Internet_missions_exceptionnelles.dt_HE) AND (Rapport_tmp.Produit_ = R_Internet_missions_exceptionnelles.Produit)"
SQL = SQL & " WHERE (((Rapport_tmp.Hr_debut_reel) Is Not Null)) OR (((Rapport_tmp.Hr_fin) Is Not Null)) OR (((Rapport_tmp.Nb_hres) Is Not Null)) OR (((Rapport_tmp.commentaires) Is Not Null));"
Set T = CurrentDb.OpenRecordset(SQL)
T.MoveFirst
Do Until T.EOF
T.Edit
Partager