1 2 3 4 5
| PARAMETERS [Forms]![Frm_Selection_Comparaison]![Lmd_Etape] Text ( 5 );
SELECT Projet.ID_P, Projet.Nom_P, Projet.Longueur, Projet.Nb_Stations, Projet.Montant_Projet, Detail_Poste.Num_Certu, Detail_Poste.Montant_PCertu, Liste_Poste_Certu.Nom_Certu, Detail_Poste_Certu.ID_SP_Certu, Detail_Poste_Certu.Montant_SP_Certu, Sous_Poste_Certu.Nom_SP_Certu, Detail_SP_Certu.ID_Desig, Detail_SP_Certu.Montant_Desig, Designation.Nom_Desig, Contient.ID_Data, Contient.CE, Contient.Etape, Contient.Indice, DATA.Unité, DATA.PU, DATA.Qté, DATA.Peraleas, DATA.Remarque, DATA.Offreur
FROM (Sous_Poste_Certu INNER JOIN (Projet INNER JOIN ((Liste_Poste_Certu INNER JOIN Detail_Poste ON Liste_Poste_Certu.Num_Certu = Detail_Poste.Num_Certu) INNER JOIN Detail_Poste_Certu ON Liste_Poste_Certu.Num_Certu = Detail_Poste_Certu.Num_Certu) ON Projet.ID_P = Detail_Poste.ID_P) ON Sous_Poste_Certu.ID_SP_Certu = Detail_Poste_Certu.ID_SP_Certu) INNER JOIN ((Designation INNER JOIN (DATA INNER JOIN Contient ON DATA.ID_Data = Contient.ID_Data) ON Designation.ID_Desig = Contient.ID_Desig) INNER JOIN Detail_SP_Certu ON Designation.ID_Desig = Detail_SP_Certu.ID_Desig) ON Sous_Poste_Certu.ID_SP_Certu = Detail_SP_Certu.ID_SP_Certu
GROUP BY Projet.ID_P, Projet.Nom_P, Projet.Longueur, Projet.Nb_Stations, Projet.Montant_Projet, Detail_Poste.Num_Certu, Detail_Poste.Montant_PCertu, Liste_Poste_Certu.Nom_Certu, Detail_Poste_Certu.ID_SP_Certu, Detail_Poste_Certu.Montant_SP_Certu, Sous_Poste_Certu.Nom_SP_Certu, Detail_SP_Certu.ID_Desig, Detail_SP_Certu.Montant_Desig, Designation.Nom_Desig, Contient.ID_Data, Contient.CE, Contient.Etape, Contient.Indice, DATA.Unité, DATA.PU, DATA.Qté, DATA.Peraleas, DATA.Remarque, DATA.Offreur, Liste_Poste_Certu.Selection, Sous_Poste_Certu.Selection
HAVING (((Contient.Etape)=[Formulaires]![Frm_Selection_Comparaison]![Lmd_Etape]) AND ((Liste_Poste_Certu.Selection)=True) AND ((Sous_Poste_Certu.Selection)=True)); |
Partager