1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| SELECT Null AS Bidon, PersonneConcernée,type AS Opération,
IIf([type]="Achat",[nombre]*[PrixUnitaire],0) AS Achat, IIf([type]="Vente",
[nombre]*[PrixUnitaire],0) AS Vente,Null AS [Vision plus], " " AS PourLeVieux, " " AS Resultat
FROM tbl_Comptes
UNION SELECT Null AS Bidon, PersonneConcernée, "x-->Total<--x" AS Opération,
Sum(IIf([type]="Achat",[nombre]*[PrixUnitaire],0)) AS Achat, Sum(IIf([type]="Vente",
[nombre]*[PrixUnitaire],0)) AS Vente," <------>" AS [Vision plus],
"Solde pour " & [PersonneConcernée]&" ==>" AS PourLeVieux,
FormatCurrency([Achat]-[Vente],2) AS Resultat
FROM tbl_Comptes
GROUP BY tbl_Comptes.PersonneConcernée
UNION SELECT "*" AS Bidon, Null AS PersonneConcernée, "xTotal Général x" AS Opération,
Sum(IIf([type]="Achat",[nombre]*[PrixUnitaire],0)) AS Achat, Sum(IIf([type]="Vente",
[nombre]*[PrixUnitaire],0)) AS Vente," <------>" AS [Vision plus],
"Solde Général ==>" AS PourLeVieux, FormatCurrency([Achat]-[Vente],2) AS Resultat
FROM tbl_Comptes; |
Partager