ACCESS交叉查询

TRANSFORM checktype SELECT name, data, checktype FROM tabmy1 GROUP BY name, data, checktype PIVOT data;