Access. Sql ??((( |
SELECT ' ' AS , K-S-NV-PD AS Itogo From qdfPayments WHERE K=(Select Sum(IncomeAmount) From qdfPayments WHERE Year(PaymentDate)<2015 And (ManagerPayCalc='' And TransactionType='') ) And S=(SELECT Sum(PaymentAmount) From qdfPayments WHERE Year(PaymentDate)<2015 And (ManagerPayCalc='' And TransactionType=' ')) And NV= (Select Sum(PaymentAmount) From qdfPayments WHERE Year(PaymentDate)<2015 And TransactionType=' ') ANd PD= (SELECT Sum(PaymentAmount)From qdfPayments WHERE Year(PaymentDate)<2015 And TransactionType=', ') -SUM(qdfPayments.IncomeAmount * (Month(PaymentDate) = 1 AND qdfPayments.ManagerPayCalc = '' AND qdfPayments.TransactionType = '')) +SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=1 AND qdfPayments.ManagerPayCalc = '' AND qdfPayments.TransactionType = ' ')) +SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=1 AND qdfPayments.TransactionType = ' ')) +SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=1 AND qdfPayments.TransactionType = ', '))+ Itogo AS , -SUM(qdfPayments.IncomeAmount * (Month(PaymentDate)=2 AND qdfPayments.ManagerPayCalc = '' AND qdfPayments.TransactionType = '')) +SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=2 AND qdfPayments.ManagerPayCalc = '' AND qdfPayments.TransactionType = ' ')) +SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=2 AND qdfPayments.TransactionType = ' '))+SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=2 AND qdfPayments.TransactionType = ', ')) + AS , -SUM(qdfPayments.IncomeAmount * (Month(PaymentDate)=3 AND qdfPayments.ManagerPayCalc = '' AND qdfPayments.TransactionType = '')) +SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=3 AND qdfPayments.ManagerPayCalc = '' AND qdfPayments.TransactionType = ' ')) +SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=3 AND qdfPayments.TransactionType = ' '))+SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=3 AND qdfPayments.TransactionType = ', ')) + AS , -SUM(qdfPayments.IncomeAmount * (Month(PaymentDate)=4 AND qdfPayments.ManagerPayCalc = '' AND qdfPayments.TransactionType = '')) +SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=4 AND qdfPayments.ManagerPayCalc = '' AND qdfPayments.TransactionType = ' ')) +SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=4 AND qdfPayments.TransactionType = ' '))+SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=4 AND qdfPayments.TransactionType = ', ')) + AS , -SUM(qdfPayments.IncomeAmount * (Month(PaymentDate)=5 AND qdfPayments.ManagerPayCalc = '' AND qdfPayments.TransactionType = '')) +SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=5 AND qdfPayments.ManagerPayCalc = '' AND qdfPayments.TransactionType = ' ')) +SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=5 AND qdfPayments.TransactionType = ' '))+SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=5 AND qdfPayments.TransactionType = ', ')) + AS , -SUM(qdfPayments.IncomeAmount * (Month(PaymentDate)=6 AND qdfPayments.ManagerPayCalc = '' AND qdfPayments.TransactionType = '')) +SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=6 AND qdfPayments.ManagerPayCalc = '' AND qdfPayments.TransactionType = ' ')) +SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=6 AND qdfPayments.TransactionType = ' '))+SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=6 AND qdfPayments.TransactionType = ', ')) + AS , -SUM(qdfPayments.IncomeAmount * (Month(PaymentDate)=7 AND qdfPayments.ManagerPayCalc = '' AND qdfPayments.TransactionType = '')) +SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=7 AND qdfPayments.ManagerPayCalc = '' AND qdfPayments.TransactionType = ' ')) +SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=7 AND qdfPayments.TransactionType = ' '))+SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=7 AND qdfPayments.TransactionType = ', ')) + AS , -SUM(qdfPayments.IncomeAmount * (Month(PaymentDate)=8 AND qdfPayments.ManagerPayCalc = '' AND qdfPayments.TransactionType = '')) +SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=8 AND qdfPayments.ManagerPayCalc = '' AND qdfPayments.TransactionType = ' ')) +SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=8 AND qdfPayments.TransactionType = ' '))+SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=8 AND qdfPayments.TransactionType = ', ')) + AS , -SUM(qdfPayments.IncomeAmount * (Month(PaymentDate)=9 AND qdfPayments.ManagerPayCalc = '' AND qdfPayments.TransactionType = '')) +SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=9 AND qdfPayments.ManagerPayCalc = '' AND qdfPayments.TransactionType = ' ')) +SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=9 AND qdfPayments.TransactionType = ' '))+SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=9 AND qdfPayments.TransactionType = ', ')) + AS , -SUM(qdfPayments.IncomeAmount * (Month(PaymentDate)=10 AND qdfPayments.ManagerPayCalc = '' AND qdfPayments.TransactionType = '')) +SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=10 AND qdfPayments.ManagerPayCalc = '' AND qdfPayments.TransactionType = ' ')) +SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=10 AND qdfPayments.TransactionType = ' '))+SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=10 AND qdfPayments.TransactionType = ', ')) + AS , -SUM(qdfPayments.IncomeAmount * (Month(PaymentDate)=11 AND qdfPayments.ManagerPayCalc = '' AND qdfPayments.TransactionType = '')) +SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=11 AND qdfPayments.ManagerPayCalc = '' AND qdfPayments.TransactionType = ' ')) +SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=11 AND qdfPayments.TransactionType = ' '))+SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=11 AND qdfPayments.TransactionType = ', ')) + AS , -SUM(qdfPayments.IncomeAmount * (Month(PaymentDate)=12 AND qdfPayments.ManagerPayCalc = '' AND qdfPayments.TransactionType = '')) +SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=12 AND qdfPayments.ManagerPayCalc = '' AND qdfPayments.TransactionType = ' ')) +SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=12 AND qdfPayments.TransactionType = ' '))+SUM(qdfPayments.PaymentAmount * (Month(PaymentDate)=12 AND qdfPayments.TransactionType = ', ')) + AS Where Year(PaymentDate)=2015
http://www.sql.ru/forum/1200110/access-sql-podzaprosy-kak-sdelat
