Id Статья
1 Активы


SELECT CostKind, -SUM(qdfPayments.PaymentAmount * (Month(PaymentDate) = 1 AND qdfPayments.TransactionType = 'Расходы прочие')) AS Январь,-SUM(qdfPayments.PaymentAmount * (Month(PaymentDate) = 2 AND qdfPayments.TransactionType = 'Расходы прочие')) AS Февраль,-SUM(qdfPayments.PaymentAmount * (Month(PaymentDate) = 3 AND qdfPayments.TransactionType = 'Расходы прочие')) AS Март,-SUM(qdfPayments.PaymentAmount * (Month(PaymentDate) = 4 AND qdfPayments.TransactionType = 'Расходы прочие')) AS Апрель,-SUM(qdfPayments.PaymentAmount * (Month(PaymentDate) = 5 AND qdfPayments.TransactionType = 'Расходы прочие')) AS Май,-SUM(qdfPayments.PaymentAmount * (Month(PaymentDate) = 6 AND qdfPayments.TransactionType = 'Расходы прочие')) AS Июнь,-SUM(qdfPayments.PaymentAmount * (Month(PaymentDate) = 7 AND qdfPayments.TransactionType = 'Расходы прочие')) AS Июль,-SUM(qdfPayments.PaymentAmount * (Month(PaymentDate) = 8 AND qdfPayments.TransactionType = 'Расходы прочие')) AS Август,-SUM(qdfPayments.PaymentAmount * (Month(PaymentDate) = 9 AND qdfPayments.TransactionType = 'Расходы прочие')) AS Сентябрь,-SUM(qdfPayments.PaymentAmount * (Month(PaymentDate) = 10 AND qdfPayments.TransactionType = 'Расходы прочие')) AS Октябрь,-SUM(qdfPayments.PaymentAmount * (Month(PaymentDate) = 11 AND qdfPayments.TransactionType = 'Расходы прочие')) AS Ноябрь, -SUM(qdfPayments.PaymentAmount * (Month(PaymentDate) = 12 AND qdfPayments.TransactionType = 'Расходы прочие')) AS Декабрь, Январь + Февраль + Март + Апрель + Май + Июнь + Июль + Август + Сентябрь + Октябрь + Ноябрь + Декабрь AS Итого
FROM qdfPayments WHERE qdfPayments.PaymentDate >= AND qdfPayments.PaymentDate < AND CostKind <>''
GROUP BY CostKind

http://www.sql.ru/forum/1198536/kak-pronumerovat-stroki-v-zaprose-access