1 2 3 4 5 6 7 8 9 10 11
| SELECT Agents.Nom_agent, Fournisseurs.Nom, [Audit - Usines].Factory, [Audit - Usines].[Factory ICS], [Audit - Usines].Adresse, [Audit - Usines].Ville, [Audit - Usines].Etat, [Audit - Usines].Factory_status, Last([Audit - Reports].Audit_date) AS DernierDeAudit_date, Last([Audit - Reports].Factory_rating) AS DernierDeFactory_rating, Last([Audit - Reports].[Total_%]) AS [DernierDeTotal_%], [Audit - Usines].Direction
FROM (([Audit - Usines] LEFT JOIN Fournisseurs ON [Audit - Usines].ID_FournisseurU = Fournisseurs.ID_Fournisseur) LEFT JOIN Agents ON Fournisseurs.ID_Agent = Agents.ID) LEFT JOIN [Audit - Reports] ON [Audit - Usines].ID_Usine = [Audit - Reports].ID_Usine
WHERE (((Fournisseurs.ID_Agent)<>4) AND (([Audit - Usines].Factory_type)="Usine") AND (([Audit - Usines].Pays) LIKE IIf([Formulaires]![FSelection_Pays]![Choix_Pays]="[Tous]","*",[Formulaires]![FSelection_Pays]![Choix_Pays]))
GROUP BY Agents.Nom_agent, Fournisseurs.Nom, [Audit - Usines].Factory, [Audit - Usines].[Factory ICS], [Audit - Usines].Adresse, [Audit - Usines].Ville, [Audit - Usines].Etat, [Audit - Usines].Factory_status, [Audit - Usines].Direction, [Audit - Usines].Direction
HAVING ((([Audit - Usines].Etat)="Active") AND (([Audit - Usines].Direction)=([Formulaires]![FSelection_Pays]![Choix_Direction])))
ORDER BY Fournisseurs.Nom; |
Partager