Добрый день. Отчет по месяцам.
См. скриншот. Надо сделать так, чтоб на одном линии были все отчеты. Убрать нули. Как это сделать?
исходный код:

SELECT IIf(Month(PaymentDate)=1 And Year(PaymentDate)=2015,SUM(qdfPayments.IncomeAmount),0) AS Jun, IIf(Month(PaymentDate)=2 And Year(PaymentDate)=2015,SUM(qdfPayments.IncomeAmount),0) AS Feb, IIf(Month(PaymentDate)=3 And Year(PaymentDate)=2015,SUM(qdfPayments.IncomeAmount),0) AS March, IIf(Month(PaymentDate)=4 And Year(PaymentDate)=2015,SUM(qdfPayments.IncomeAmount),0) AS Apr, IIf(Month(PaymentDate)=5 And Year(PaymentDate)=2015,SUM(qdfPayments.IncomeAmount),0) AS May, IIf(Month(PaymentDate)=6 And Year(PaymentDate)=2015,SUM(qdfPayments.IncomeAmount),0) AS June, IIf(Month(PaymentDate)=7 And Year(PaymentDate)=2015,SUM(qdfPayments.IncomeAmount),0) AS July, IIf(Month(PaymentDate)=8 And Year(PaymentDate)=2015,SUM(qdfPayments.IncomeAmount),0) AS Aug, IIf(Month(PaymentDate)=9 And Year(PaymentDate)=2015,SUM(qdfPayments.IncomeAmount),0) AS Sept, IIf(Month(PaymentDate)=10 And Year(PaymentDate)=2015,SUM(qdfPayments.IncomeAmount),0) AS Oct, IIf(Month(PaymentDate)=11 And Year(PaymentDate)=2015,SUM(qdfPayments.IncomeAmount),0) AS Dov, IIf(Month(PaymentDate)=12 And Year(PaymentDate)=2015,SUM(qdfPayments.IncomeAmount),0) AS [Dec]
FROM qdfPayments
GROUP BY Month(PaymentDate), Year(PaymentDate);

http://www.sql.ru/forum/1197639/access-vyvesti-otchet-po-mesyacam