Transform And Pivot In Access 2013 Sql

How can I get second table from first table using TRANSFORM and PIVOT functions: TABLE_01 Config_ID | ConfigField | ConfigValue -----------------------------------------

Solution 1:

It looks like you are missing the aggregate function in the TRANSFORM:

TRANSFORM Max(ConfigValue)
SELECT Config_ID
FROM TABLE_01
GROUPBY Config_ID
PIVOT ConfigField 

Solution 2:

I have found solution by myself:

TRANSFORM FIRST(ConfigValue)
SELECT Config_ID
FROM TABLE_01
GROUPBY Config_ID
PIVOT ConfigField

Thanks everyone for help.