, 10 2016 . 14:10
+
2014
Center ----------
------200------400--------400
2015 + 2014
Center -------------------------------------------
------
400+200------
400+200+400=
1000 !!!! ??
SELECT Center, -SUM(qdfPayments.IncomePaymentSumCalc * (Month(PaymentDate) = 1)) + AS ,
-SUM(qdfPayments.IncomePaymentSumCalc * (Month(PaymentDate) = 2)) + AS ,
-SUM(qdfPayments.IncomePaymentSumCalc * (Month(PaymentDate) = 3))+ AS ,
-SUM(qdfPayments.IncomePaymentSumCalc * (Month(PaymentDate) = 4))+ AS ,
-SUM(qdfPayments.IncomePaymentSumCalc * (Month(PaymentDate) = 5))+ AS ,
-SUM(qdfPayments.IncomePaymentSumCalc * (Month(PaymentDate) = 6))+ AS ,
-SUM(qdfPayments.IncomePaymentSumCalc * (Month(PaymentDate) = 7))+ AS ,
-SUM(qdfPayments.IncomePaymentSumCalc * (Month(PaymentDate) = 8))+ AS ,
-SUM(qdfPayments.IncomePaymentSumCalc * (Month(PaymentDate) = 9))+ AS ,
-SUM(qdfPayments.IncomePaymentSumCalc * (Month(PaymentDate) = 10))+ AS ,
-SUM(qdfPayments.IncomePaymentSumCalc * (Month(PaymentDate) = 11))+ AS ,
-SUM(qdfPayments.IncomePaymentSumCalc * (Month(PaymentDate) = 12))+ AS , AS
FROM qdfPayments WHERE Year(PaymentDate) <=2015 AND Center<>''
GROUP BY Center
http://www.sql.ru/forum/1199887/access-nado-sdelat-narastaushhiy-itog-po-mesyacam-chtoby-uchityvalsya-za-predydushhie-goda
