, 11 2018 . 11:45
+
! :
PARAMETERS [Forms]![]![] Long, [forms]![]![d1] DateTime, [forms]![]![d2] DateTime;
TRANSFORM Sum(..) AS [Sum-_]
SELECT ., ..
FROM
GROUP BY ., ..
PIVOT .;
, :
PIVOT . 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');
. .
https://www.sql.ru/forum/1306542/nazvanie-stolbcov-v-perekrestnom-zaprose
