-

   rss_sql_ru_access_programming

 - e-mail

 

 -

 LiveInternet.ru:
: 16.03.2006
:
:
: 4

:


Pivot Ms Access

, 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


: [1] []
 

:
: 

: ( )

:

  URL