ANALYSE PROMOS

SELECT ClientPromotionsPlanning.DateExpedition, ClientPromotionsPlanning.NbreColis, ClientPromotionsPlanning.VolumePrevu, CLIENTSX.RaisonSocLiv, [requete article].ARTICLESX.Libelle, [requete article].NomFamille, [requete article].STOCK1.Libelle, ClientPromotions.NomPromotion, ClientPromotionsPlanning.NbreColisRealise, ClientPromotionsPlanning.VolumeRealise, ClientsSousGroupe1.NomSousGroupe, ClientsGroupe1.NomGroupe
FROM ((((ClientPromotions LEFT JOIN ClientPromotionsPlanning ON ClientPromotions.NumAuto = ClientPromotionsPlanning.NumPromotion) LEFT JOIN CLIENTSX ON ClientPromotions.IdClient = CLIENTSX.NumAuto) LEFT JOIN [requete article] ON ClientPromotions.RefArticle = [requete article].Reference) LEFT JOIN ClientsGroupe1 ON CLIENTSX.NumGroupeClient = ClientsGroupe1.NumAuto) LEFT JOIN ClientsSousGroupe1 ON CLIENTSX.NumSousGroupe = ClientsSousGroupe1.NumAuto
WHERE (((ClientPromotionsPlanning.NbreColis)>0) AND (([requete article].NomGamme)="MOULES") AND ((IIf(Year([dateExpedition])>=2023,"oui","non"))="oui"));