TRANSFORM Sum(HOUR_DATE) AS [Sum-HOUR_DATE]
SELECT ID, FIO, Sum(HOUR_DATE) AS Итого
FROM (
SELECT e.ID, e.FIO, t.DATE_RECORD, t.HOUR_DATE
FROM (
SELECT ID, DATE_RECORD, HOUR_DATE
FROM TABEL_TBL
WHERE DATE_RECORD Between #5/1/2010# And #5/31/2010#
) t
RIGHT JOIN SPR_NAME_MAN_TBL e ON t.ID = e.ID
) q1
GROUP BY ID, FIO
PIVOT Day(DATE_RECORD) In (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31);
|