1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
|
SELECT RESEAUX.LB_RESEAUX
FROM RESEAUX INNER JOIN (((ENTREPOTS INNER JOIN DATA_HYPER ON ENTREPOTS.CD_ENT = DATA_HYPER.CD_ENT) INNER JOIN DATA_PROXI ON ENTREPOTS.CD_ENT = DATA_PROXI.CD_ENT) INNER JOIN DATA_SUPER ON ENTREPOTS.CD_ENT = DATA_SUPER.CD_ENT) ON RESEAUX.LB_RESEAUX = ENTREPOTS.LB_RESEAUX
WHERE (([Formulaires]![CATB]![Cocher1_HYPER]="VRAI" And [Formulaires]![CATB]![Cocher2_SUPER]="FAUX")) ( SELECT DATA_HYPER.N°audit, DATA_HYPER.UE, DATA_HYPER.CD_ENT, DATA_HYPER.LB_ENT, DATA_HYPER.Mag, DATA_HYPER.Ano, DATA_HYPER.Audités, DATA_HYPER.[Ecart Fin], DATA_HYPER.PCI FROM DATA_HYPER
WHERE (((DATA_HYPER.Date) Between [Formulaires]![CATB]![DATE_DEB] And [Formulaires]![CATB]![DATE_FIN]))
GROUP BY DATA_HYPER.N°audit, DATA_HYPER.UE, DATA_HYPER.CD_ENT, DATA_HYPER.LB_ENT, DATA_HYPER.Mag, DATA_HYPER.Ano, DATA_HYPER.Audités, DATA_HYPER.[Ecart Fin], DATA_HYPER.PCI
ORDER BY DATA_HYPER.CD_ENT)
OR (([Formulaires]![CATB]![Cocher1_HYPER]="FAUX" And [Formulaires]![CATB]![Cocher2_SUPER]="VRAI")) (SELECT DATA_SUPER.N°audit, DATA_SUPER.UE, DATA_SUPER.CD_ENT, DATA_SUPER.LB_ENT, DATA_SUPER.Mag, DATA_SUPER.Ano, DATA_SUPER.Audités, DATA_SUPER.[Ecart Fin], DATA_SUPER.PCI
FROM DATA_SUPER
WHERE (((DATA_SUPER.Date) Between [Formulaires]![CATB]![DATE_DEB] And [Formulaires]![CATB]![DATE_FIN]))
GROUP BY DATA_SUPER.N°audit, DATA_SUPER.UE, DATA_SUPER.CD_ENT, DATA_SUPER.LB_ENT, DATA_SUPER.Mag, DATA_SUPER.Ano, DATA_SUPER.Audités, DATA_SUPER.[Ecart Fin], DATA_SUPER.PCI)
OR (([Formulaires]![CATB]![Cocher3_PROXI]="VRAI")) (SELECT DATA_PROXI.N°audit, DATA_PROXI.UE, DATA_PROXI.CD_ENT, DATA_PROXI.LB_ENT, DATA_PROXI.Mag, DATA_PROXI.Ano, DATA_PROXI.Audités, DATA_PROXI.[Ecart Fin], DATA_PROXI.PCI
FROM DATA_PROXI
WHERE (((DATA_PROXI.Date) Between [Formulaires]![CATB]![DATE_DEB] And [Formulaires]![CATB]![DATE_FIN]))
GROUP BY DATA_PROXI.N°audit, DATA_PROXI.UE, DATA_PROXI.CD_ENT, DATA_PROXI.LB_ENT, DATA_PROXI.Mag, DATA_PROXI.Ano, DATA_PROXI.Audités, DATA_PROXI.[Ecart Fin], DATA_PROXI.PCI)
; |
Partager