1 2 3 4 5 6 7 8
| SELECT DISTINCT D.CommandeN, D.NomClient, D.NFacture, D.Annee, D.TTC, D.HT, D.Commission, D.CommissionHT, D.Mois, D.Rue, D.N, D.Ville, D.CodePostal, D.NomClient2, D.Civilite, D1.Mois, D1.Annee, D1.NFacture, SUM(D.TTC), (D.TTC * 1.196) AS D."TTC * 1,196", (((D.Commission * D.TTC) * 1.196) / 100.0) AS D."Commission * TTC * 1,196"
FROM "C:\gestion /Commission.DB" D, "mois.DB" D1
WHERE
(D1.Mois = D.Mois)
AND (D1.Annee = D.Annee)
AND (D1.NFacture = D.NFacture)
GROUP BY D.CommandeN, D.NomClient, D.NFacture, D.Annee, D.TTC, D.HT, D.Commission, D.CommissionHT, D.Mois, D.Rue, D.N, D.Ville, D.CodePostal, D.NomClient2, D.Civilite, D1.Mois, D1.Annee, D1.NFacture
ORDER BY D.CommandeN, D.NomClient, D.NFacture, D.Annee, D.TTC, D.HT, D.Commission, D.CommissionHT, D.Mois, D.Rue, D.N, D.Ville, D.CodePostal, D.NomClient2, D.Civilite, D1.Mois, D1.Annee, D1.NFacture |
Partager