1 2 3 4 5
| SELECT T1.numcpte, T1.codecpte, T1.libellecpte, (SELECT sum(T2.montantoprtiondebit) as Expr1 FROM base_balance as T2 Where ((T1.numcpte=T2.numcpte) and ((T2.dateoprtion)<forms!ouvrir_balance!date_debut) and (T2.classe<6)) group by T2.numcpte) AS soldeantdebit, (SELECT sum(T2.montantoprtioncredit) as Expr1 FROM base_balance as T2 Where ((T1.numcpte=T2.numcpte) and ((T2.dateoprtion)<forms!ouvrir_balance!date_debut) and (T2.classe<6)) group by T2.numcpte) AS soldeantcredit, Sum(T1.montantoprtiondebit) AS soldemvtdebi, Sum(T1.montantoprtioncredit) AS soldemvtcredit
FROM base_balance AS T1
WHERE (((T1.dateoprtion) Between forms!ouvrir_balance!date_debut And forms!ouvrir_balance!date_fin))
GROUP BY T1.numcpte, T1.codecpte, T1.libellecpte
ORDER BY T1.codecpte; |
Partager