1 2 3 4 5
| Select
(Select (Sum(IIF(TypDoc = 'FC',Montant - MtRegl,0))) - (Sum(IIF(TypDoc = 'AV',Montant- MtRegl,0))) From FacFin Where ((DateEch) Between #03/01/2020# and #03/31/2020#) And ((CodeTiers) = '1234567890')) As MontantEch1,
(Select (Sum(IIF(TypDoc = 'FC',Montant - MtRegl,0))) - (Sum(IIF(TypDoc = 'AV',Montant- MtRegl,0))) From FacFin Where ((DateEch) Between #02/01/2020# and #02/28/2020#) And ((CodeTiers) = '1234567890')) As MontantEch2,
(Select (Sum(IIF(TypDoc = 'FC',Montant - MtRegl,0))) - (Sum(IIF(TypDoc = 'AV',Montant- MtRegl,0))) From FacFin Where ((DateEch) Between #01/01/2020# and #01/31/2020#) And ((CodeTiers) = '1234567890')) As MontantEch3
From FacFin |
Partager