1 2 3 4
| SELECT DOSSIER.N°DOSSIER, DOSSIER.[NOM DOSSIER], Travail.Exercice, [TYPE DOSSIER].[NOM TYPE], TEST2.EstimationIntervenant, TEST3.Factsstt.MontantHT, TEST3.Facturation.MontantHT, Travail.Facturable, TEST.[Frais KM], TEST.FraisHorsKM
FROM [TYPE DOSSIER] INNER JOIN (DOSSIER INNER JOIN (TEST2 INNER JOIN (TEST INNER JOIN (Travail INNER JOIN TEST3 ON Travail.N°Dossier = TEST3.N°DOSSIER) ON TEST.N°DOSSIER = TEST3.N°DOSSIER) ON TEST2.N°DOSSIER = TEST3.N°DOSSIER) ON DOSSIER.N°DOSSIER = TEST3.N°DOSSIER) ON [TYPE DOSSIER].TYPE = Travail.TYPE
GROUP BY DOSSIER.N°DOSSIER, DOSSIER.[NOM DOSSIER], Travail.Exercice, [TYPE DOSSIER].[NOM TYPE], TEST2.EstimationIntervenant, TEST3.Factsstt.MontantHT, TEST3.Facturation.MontantHT, Travail.Facturable, TEST.[Frais KM], TEST.FraisHorsKM
HAVING (((DOSSIER.N°DOSSIER) Like "*" & [Formulaires]![fRentabilitéDossier]![cboNOMDOSSIER] & "*") AND ((Travail.Exercice) Like "*" & [Formulaires]![fRentabilitéDossier]![cboExercice] & "*") AND (([TYPE DOSSIER].[NOM TYPE]) Like "*" & [Formulaires]![fRentabilitéDossier]![cboTYPE] & "*") AND ((Travail.Facturable)="o")); |
Partager