TRANSFORM Sum(HOUR_DATE) AS [Sum-HOUR_DATE]
SELECT ID, FIO, Sum(HOUR_DATE) AS Итого
FROM (
SELECT e.ID, e.FIO, t.HOUR_DATE, t.DATE_RECORD
FROM SPR_NAME_MAN_TBL e INNER JOIN TABEL_TBL t ON e.ID = t.ID
WHERE t.DATE_RECORD Between #5/01/2010# And #5/31/2010#
) 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);
|