BDDCOMPTA

avoirs : 

SELECT CLIENTS.RaisonSocLiv, LIGNES_BL.DateExpedition, ARTICLES.Libelle, LITIGES.PrécisionQualité, LITIGES.MontantAvoir, LITIGES.LITnbColis, ArticleFamille.NomFamille, LITIGES.LibelleLitige
FROM ((((LIGNES_BL LEFT JOIN LITIGES ON LIGNES_BL.IdLigne = LITIGES.IDligneBL) LEFT JOIN ARTICLES ON LIGNES_BL.IDReference = ARTICLES.Reference) LEFT JOIN CLIENTS ON LIGNES_BL.IDclient = CLIENTS.IDClient) LEFT JOIN GAMME_ARTICLE ON ARTICLES.AAAIdGamme = GAMME_ARTICLE.IdGamme) LEFT JOIN ArticleFamille ON ARTICLES.Code_Famille = ArticleFamille.IDfamille
WHERE (((LIGNES_BL.DateExpedition)>=#1/1/2017# And (LIGNES_BL.DateExpedition)<=Date()) AND ((LITIGES.MontantAvoir)>0) AND ((GAMME_ARTICLE.NomGamme)="MOULES"));

facture : 

SELECT FACTURES.NoFacture, FACTURES.DateFacture, FACTURES.HT, FACTURES.AvoirRemise, FACTURES.Remfac1, FACTURES.Remfac, FACTURES.AvoirSurBL
FROM FACTURES
WHERE (((FACTURES.DateFacture) Between #1/1/2019# And Date()) AND ((FACTURES.HT)<0) AND ((CBool([AvoirAutres]))=0));

lignefacturesv2 : 

SELECT facture.NoFacture, facture.DateFacture, LIGNES_BL.DateExpedition, [facture]![HT] AS HTFACTURE, [FacturesLignes]![HTligne] AS HTLIGNE, [facture]![Remfac] AS REMFAC, [FacturesLignes]![HTligne]-[facture]![Remfac] AS HTLIGNEremfac, [requete article].ARTICLES.Libelle, [requete article].NomGamme, [requete article].NomFamille, FacturesLignes.CodeTVA, LITIGES.LibelleLitige, LITIGES.PrécisionQualité
FROM (facture LEFT JOIN ((FacturesLignes LEFT JOIN [requete article] ON FacturesLignes.IDreference = [requete article].Reference) LEFT JOIN LIGNES_BL ON FacturesLignes.AV_IDLigneBL = LIGNES_BL.IdLigne) ON facture.NoFacture = FacturesLignes.No_Facture) LEFT JOIN LITIGES ON FacturesLignes.AV_IDLigneBL = LITIGES.IDligneBL
WHERE (((CBool([AvoirSurBL]))=-1) AND ((CBool([AvoirRemise]))=0));

requete article : 

SELECT ARTICLES.Reference, ARTICLES.Libelle, ArticleFamille.NomFamille, STOCK.Libelle, GAMME_ARTICLE.NomGamme
FROM ((ARTICLES LEFT JOIN ArticleFamille ON ARTICLES.Code_Famille = ArticleFamille.IDfamille) LEFT JOIN GAMME_ARTICLE ON ARTICLES.AAAIdGamme = GAMME_ARTICLE.IdGamme) LEFT JOIN STOCK ON ARTICLES.IDstock = STOCK.IDstock;

requete client : 

SELECT CLIENTS.IDClient, CLIENTS.RaisonSocLiv, ClientsSousGroupe.NomSousGroupe, ClientsGroupe.NomGroupe, ClientsMarche.NomTypeMarché
FROM ((CLIENTS LEFT JOIN ClientsGroupe ON CLIENTS.IdGroupeClient = ClientsGroupe.IdGroupeClient) LEFT JOIN ClientsSousGroupe ON CLIENTS.IDSousGroupe = ClientsSousGroupe.IDSousGroupe) LEFT JOIN ClientsMarche ON CLIENTS.Id_TypeMarch = ClientsMarche.IDMarché;