Skip to main content

basedonnéeV2

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"));

Arch req ventes+litiges huitres : 

SELECT LignesCommandes.IDclient, LignesCommandes.DateExpedition, LignesCommandes.IDReference, LignesCommandes.NbreColis, LignesCommandes.PoidsLigne, LITIGES.LibelleLitige, LITIGES.PrecisionQualite, LITIGES.LITnbColis, LITIGES.LITpoids
FROM LignesCommandes LEFT JOIN LITIGES ON LignesCommandes.NumAuto = LITIGES.IDligneBL
WHERE (((LignesCommandes.DateExpedition)>=#1/1/2016# And (LignesCommandes.DateExpedition)<#6/30/2019#) AND ((CBool([PrevisionInterne]))=0) AND ((FormatNumber([IDgamme],0))<>"1"))
ORDER BY LignesCommandes.DateExpedition;

archive req ventes+litiges :

SELECT LignesCommandes.IDclient, LignesCommandes.DateExpedition, LignesCommandes.IDReference, LignesCommandes.NbreColis, LignesCommandes.PoidsLigne, LITIGES.LibelleLitige, LITIGES.PrecisionQualite, LITIGES.LITnbColis, LITIGES.LITpoids
FROM LignesCommandes LEFT JOIN LITIGES ON LignesCommandes.NumAuto = LITIGES.IDligneBL
WHERE (((LignesCommandes.DateExpedition)>=#1/1/2016# And (LignesCommandes.DateExpedition)<#10/31/2022#) AND ((CBool([PrevisionInterne]))=0) AND ((FormatNumber([IDgamme],0))<>"1"))
ORDER BY LignesCommandes.DateExpedition;

avoirs maj : 

SELECT CLIENTSX.RaisonSocLiv, LignesCommandes.DateExpedition, ARTICLESX.Libelle, LITIGES.PrecisionQualite, LITIGES.MontantAvoir, ArticleFamille.NomFamille
FROM ((((LignesCommandes LEFT JOIN CLIENTSX ON LignesCommandes.IDclient = CLIENTSX.NumAuto) LEFT JOIN ARTICLESX ON LignesCommandes.IDReference = ARTICLESX.Reference) LEFT JOIN LITIGES ON LignesCommandes.NumAuto = LITIGES.IDligneBL) LEFT JOIN ArticleGammeX ON ARTICLESX.IdGamme = ArticleGammeX.NumAuto) LEFT JOIN ArticleFamille ON ARTICLESX.Code_Famille = ArticleFamille.NumAuto
WHERE (((LignesCommandes.DateExpedition)>=#1/1/2019# And (LignesCommandes.DateExpedition)<=Date()) AND ((LITIGES.MontantAvoir)>0) AND ((LITIGES.LibelleLitige)="Produit") AND ((ArticleGammeX.NomGamme)="MOULES"));

bilan eai ventes moules sans vrac 2023 2024 : 

SELECT LignesCommandes.DateExpedition, LignesCommandes.PoidsLigne
FROM LignesCommandes
WHERE (((LignesCommandes.DateExpedition) Between #1/1/2022# And #12/31/2024#) AND ((CBool([PrevisionInterne]))=0) AND (Not (LignesCommandes.CodeFamille)=102) AND ((LignesCommandes.IDgamme)=1));

correction sans fam vrac : 

SELECT LignesCommandes.DateExpedition, LignesCommandes.PoidsLigne
FROM LignesCommandes
WHERE (((LignesCommandes.DateExpedition) Between #1/1/2022# And #12/31/2023#) AND ((CBool([PrevisionInterne]))=0) AND ((LignesCommandes.CodeFamille)=102));

PROMOTIONS : 

SELECT ClientPromotionsPlanning.DateExpedition, ClientPromotionsPlanning.NbreColis, ClientPromotionsPlanning.VolumePrevu, CLIENTSX.RaisonSocLiv, ClientsGroupe1.NomGroupe, ClientsSousGroupe1.NomSousGroupe, [requete article].ARTICLESX.Libelle, [requete article].NomFamille, [requete article].STOCK1.Libelle, [requete article].NomGamme, ClientPromotions.NomPromotion, ClientPromotions.Phase, ClientPromotions.OrigineClient
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])>=Year(Date()),"oui","non"))="oui") AND ((IIf(DatePart("ww",[DateExpedition])>=DatePart("ww",Date()),"oui","non"))="oui"));

requete article : 

SELECT ARTICLESX.Reference, ARTICLESX.Libelle, ArticleFamille.NomFamille, STOCK1.Libelle, ArticleGammeX.NomGamme
FROM ((ARTICLESX LEFT JOIN ArticleGammeX ON ARTICLESX.IdGamme = ArticleGammeX.NumAuto) LEFT JOIN STOCK1 ON ARTICLESX.IDstock = STOCK1.IDstock) LEFT JOIN ArticleFamille ON ARTICLESX.Code_Famille = ArticleFamille.NumAuto
WHERE (((ARTICLESX.IdGamme)=1));

requete article huitres : 

SELECT ARTICLESX.Reference, ARTICLESX.Libelle, ArticleFamille.NomFamille, STOCK1.Libelle, ArticleGammeX.NomGamme
FROM ((ARTICLESX LEFT JOIN STOCK1 ON ARTICLESX.IDstock = STOCK1.IDstock) LEFT JOIN ArticleFamille ON ARTICLESX.Code_Famille = ArticleFamille.NumAuto) LEFT JOIN ArticleGammeX ON ARTICLESX.IdGamme = ArticleGammeX.NumAuto
WHERE (((FormatNumber([ARTICLESX]![IdGamme],0))<>1));

requete client : 

SELECT CLIENTSX.NumAuto, CLIENTSX.RaisonSocLiv, ClientsSousGroupe1.NomSousGroupe, ClientsGroupe1.NomGroupe, ClientsMarche1.NomTypeMarche
FROM ((CLIENTSX LEFT JOIN ClientsMarche1 ON CLIENTSX.Id_TypeMarch = ClientsMarche1.NumAuto) LEFT JOIN ClientsGroupe1 ON CLIENTSX.NumGroupeClient = ClientsGroupe1.NumAuto) LEFT JOIN ClientsSousGroupe1 ON CLIENTSX.NumSousGroupe = ClientsSousGroupe1.NumAuto;

requete vente moules promos :

SELECT LignesCommandes.DateExpedition, LignesCommandes.PoidsLigne, [requete article].ARTICLESX.Libelle, [requete article].NomFamille, [requete article].STOCK1.Libelle, [requete client].RaisonSocLiv, [requete client].NomTypeMarche, LignesCommandes.Idpromo, LignesCommandes.NumAutoPromotion
FROM (LignesCommandes LEFT JOIN [requete article] ON LignesCommandes.IDReference = [requete article].Reference) LEFT JOIN [requete client] ON LignesCommandes.IDclient = [requete client].NumAuto
WHERE (((LignesCommandes.NumAutoPromotion)<>0) AND ((CBool([PrevisionInterne]))=0) AND ((LignesCommandes.IDgamme)=1) AND ((IIf(Year([dateExpedition])=Year(Date()),"oui","non"))="oui"));

requete vente moules quotidiennes : 

SELECT LignesCommandes.DateExpedition, LignesCommandes.PoidsLigne, LignesCommandes.idStock
FROM LignesCommandes
WHERE (((LignesCommandes.DateExpedition)=Date()) AND ((CBool([PrevisionInterne]))=0) AND ((LignesCommandes.IDgamme)=1) AND (Not (LignesCommandes.CodeFamille)=102));

requete ventes+litiges : 

SELECT LignesCommandes.IDclient, LignesCommandes.DateExpedition, LignesCommandes.IDReference, LignesCommandes.NbreColis, LignesCommandes.PoidsLigne, LITIGES.LibelleLitige, LITIGES.PrecisionQualite, LITIGES.LITnbColis, LITIGES.LITpoids
FROM LignesCommandes LEFT JOIN LITIGES ON LignesCommandes.NumAuto = LITIGES.IDligneBL
WHERE (((LignesCommandes.DateExpedition)>=#11/1/2022# And (LignesCommandes.DateExpedition)<=Date()) AND ((CBool([PrevisionInterne]))=0) AND ((FormatNumber([IDgamme],0))<>"1"))
ORDER BY LignesCommandes.DateExpedition;

requete ventes+litiges huitres : 

SELECT LignesCommandes.IDclient, LignesCommandes.DateExpedition, LignesCommandes.IDReference, LignesCommandes.NbreColis, LignesCommandes.PoidsLigne, LITIGES.LibelleLitige, LITIGES.PrecisionQualite, LITIGES.LITnbColis, LITIGES.LITpoids
FROM LignesCommandes LEFT JOIN LITIGES ON LignesCommandes.NumAuto = LITIGES.IDligneBL
WHERE (((LignesCommandes.DateExpedition)>#6/30/2019# And (LignesCommandes.DateExpedition)<=Date()) AND ((CBool([PrevisionInterne]))=0) AND ((FormatNumber([IDgamme],0))<>"1"))
ORDER BY LignesCommandes.DateExpedition;

Back to top