1 2 3 4
|
SELECT TbAtt.*, TbAtt.VEN, TbAtt.VENlie, TbAtt.Origine, TbAtt.Commune, TbAtt.ND, TbAtt.NPoteau1, TbAtt.NPoteau2, TbAtt.NPoteau3, TbAtt.NPoteau4, TbAtt.NPoteau5, TbAtt.NPoteau6, TbAtt.NDecharge, TbCAFF.CAFF, TbCodeAtt.CodeAtt, TbTech.Nom, TbEtatW.EtatW, TbEtatAtt.EtatAtt
FROM TbTech RIGHT JOIN (TbEtatAtt RIGHT JOIN (TbEtatW RIGHT JOIN (TbCodeAtt RIGHT JOIN (TbCAFF RIGHT JOIN TbAtt ON TbCAFF.IDCAFF = TbAtt.IDCAFF) ON TbCodeAtt.IDCodeAtt = TbAtt.IDCodeAtt) ON TbEtatW.IDEtatW = TbAtt.IDEtatW) ON TbEtatAtt.IDEtatAtt = TbAtt.IDEtatAtt) ON TbTech.IDTech = TbAtt.IDTech
WHERE (((TbAtt.VEN) Like "*" & [Formulaires]![FmRechercheAtt]![zdtFiltreVEN] & "*") AND ((TbAtt.VENlie) Like "*" & [Formulaires]![FmRechercheAtt]![zdtFiltreVENlie] & "*") AND ((TbAtt.Origine) Like "*" & [Formulaires]![FmRechercheAtt]![zdtFiltreOrigine] & "*") AND ((TbAtt.Commune) Like "*" & [Formulaires]![FmRechercheAtt]![zdlFiltreCommune] & "*") AND ((TbAtt.ND) Like "*" & [Formulaires]![FmRechercheAtt]![zdtFiltreND] & "*") AND ((TbAtt.NPoteau1) Like "*" & [Formulaires]![FmRechercheAtt]![zdtFiltrePoteau] & "*") AND ((TbCAFF.CAFF) Like "*" & [Formulaires]![FmRechercheAtt]![zdlFiltreCAFF] & "*")) OR (((TbAtt.NPoteau2) Like "*" & [Formulaires]![FmRechercheAtt]![zdtFiltrePoteau] & "*")) OR (((TbAtt.NPoteau3) Like "*" & [Formulaires]![FmRechercheAtt]![zdtFiltrePoteau] & "*")) OR (((TbAtt.NPoteau4) Like "*" & [Formulaires]![FmRechercheAtt]![zdtFiltrePoteau] & "*")) OR (((TbAtt.NPoteau5) Like "*" & [Formulaires]![FmRechercheAtt]![zdtFiltrePoteau] & "*")) OR (((TbAtt.NPoteau6) Like "*" & [Formulaires]![FmRechercheAtt]![zdtFiltrePoteau] & "*") AND ((TbAtt.NDecharge) Like "*" & [Formulaires]![FmRechercheAtt]![zdtFiltreNDecharge] & "*") AND ((TbCodeAtt.CodeAtt) Like "*" & [Formulaires]![FmRechercheAtt]![zdlFiltreCodeAtt] & "*") AND ((TbTech.Nom) Like "*" & [Formulaires]![FmRechercheAtt]![zdlFiltreTech] & "*") AND ((TbEtatW.EtatW) Like "*" & [Formulaires]![FmRechercheAtt]![zdlFiltreEtatW] & "*") AND ((TbEtatAtt.EtatAtt) Like "*" & [Formulaires]![FmRechercheAtt]![zdlFiltreEtatAtt] & "*")); |
Partager