PIVOT sql with fixed value...

[sal21]

Code: Select all

SQL = "TRANSFORM ecc...." & _
        " SELECT ecc" & _
        " FROM ecc..." & _
        " Where ecc...'" & _
        " GROUP BY ecc..." & _
        " PIVOT VER.ANNO"

instead to use VER.ANNO, possible to use a string ('2012','2013',...'2017')...

[HansV]

You can use

Code: Select all

SQL = "TRANSFORM ecc..." & _
        " SELECT ecc..." & _
        " FROM ecc..." & _
        " WHERE ecc...'" & _
        " GROUP BY ecc..." & _
        " PIVOT VER.ANNO IN ('2012','2013','2014','2015','2016','2017')"

[sal21]

You can use

Code: Select all

SQL = "TRANSFORM ecc..." & _
        " SELECT ecc..." & _
        " FROM ecc..." & _
        " WHERE ecc...'" & _
        " GROUP BY ecc..." & _
        " PIVOT VER.ANNO IN ('2012','2013','2014','2015','2016','2017')"

hummm...

but really my prob is to rapresent in other case although not all records have values for years...

[HansV]

If you use

PIVOT VER.ANNO IN ('2012','2013','2014','2015','2016','2017')

the query will display a column for 2012, 2013, ..., 2017, whether there are records for all those years or not.

[sal21]

If you use

PIVOT VER.ANNO IN ('2012','2013','2014','2015','2016','2017')

the query will display a column for 2012, 2013, ..., 2017, whether there are records for all those years or not.

sorry for delay...
The tips is perfect!
Tks.