rss sql ru access programming
rss_sql_ru_access_programming

 -

rss_sql_ru_access_programming

 - e-mail

 

 -

LiveInternet.ru:
: 16.03.2006
:
:
: 4

:


Sql, Access. ","

, 19 2016 . 15:57 +
, ? ( !)

SELECT 2 AS ID, '' AS , 
-SUM(qdfPayments.PaymentAmount * (Month(PaymentDate) = 1)) AS ,
-SUM(qdfPayments.PaymentAmount * (Month(PaymentDate) = 2)) AS ,
-SUM(qdfPayments.PaymentAmount * (Month(PaymentDate) = 3)) AS ,
-SUM(qdfPayments.PaymentAmount * (Month(PaymentDate) = 4)) AS ,
-SUM(qdfPayments.PaymentAmount * (Month(PaymentDate) = 5)) AS , 
-SUM(qdfPayments.PaymentAmount * (Month(PaymentDate) = 6)) AS ,
-SUM(qdfPayments.PaymentAmount * (Month(PaymentDate) = 7)) AS , 
-SUM(qdfPayments.PaymentAmount * (Month(PaymentDate) = 8)) AS , 
-SUM(qdfPayments.PaymentAmount * (Month(PaymentDate) = 9)) AS ,
-SUM(qdfPayments.PaymentAmount * (Month(PaymentDate) = 10)) AS ,
-SUM(qdfPayments.PaymentAmount * (Month(PaymentDate) = 11)) AS , 
-SUM(qdfPayments.PaymentAmount * (Month(PaymentDate) = 12)) AS ,  +  +  +  +  +  +  +  +  +  +  +  AS 
FROM qdfPayments
WHERE qdfPayments.PaymentDate >= 2015 AND qdfPayments.PaymentDate < =2015AND qdfPayments.ManagerPayCalc = '' AND qdfPayments.TransactionType = '  '

http://www.sql.ru/forum/1201471/sql-access-kak-ubrat-nuli-posle-v-itog-bez-zapyatoy-i-desyatichnyh-znacheniy


— — : [1] []
 

:
: 

: ( )

:

  URL