1 2 3 4 5 6 7 8 9
| SELECT
A.numero, B.numero, B.libelle, C.nom, D.numero, Concatener_Personne(E.nomC,E.numD) AS personnes, Sum([jours]*[taux]) AS somme, E.frais, [somme]+[frais] AS total
FROM
((A LEFT JOIN B ON A.numero=B.NumA) LEFT JOIN (C LEFT JOIN D ON C.nom=D.nomC) ON (B.numA=C.numA) AND (B.numero=C.numB)) LEFT JOIN E ON (D.numero=E.numD) AND (D.nomC=E.numD)
GROUP BY
A.numero, B.numero, B.libelle, C.nom, D.numero, Concatener_Personne(E.nomC,E.numD) AS personnes, Sum([jours]*[taux]) AS somme, E.frais, [somme]+[frais] AS total,
Month([dateX]), Year([dateX]), D.Etat
HAVING
(((Month([dateX]))=Formulaires!Facture!mois) And ((Year([dateX]))=Formulaires!Facture!annee) And ((D.etat)="OK")); |
Partager