, 20 2019 . 17:41
+
, .
Pivot, .
, +1, +2
( )
, , .
, , .
, " FROM"
SELECT , +1,+2
FROM
GROUP BY
PIVOT ( for in ( +1, +2))
SELECT UserFullNameCalc, FORMAT(Now(),'dd.mm.yyyy'),FORMAT(Now()+1,'dd.mm.yyyy')
FROM qdfWorkDay
GROUP BY UserFullNameCalc
PIVOT (WorkHourCalc for DayNowCalc in (FORMAT(Now(),'dd.mm.yyyy'),FORMAT(Now()+1,'dd.mm.yyyy')))
https://www.sql.ru/forum/1311735/kak-rabotaet-pivot-v-ms-access