MS Access中枢转的语法与sql server不同。您必须使用该
TRANSFORM功能来旋转数据。
语法将类似于以下内容：
TRANSFORM SUM([Retention & Graduation].Hc)SELECt [Retention & Graduation].Year, [Retention & Graduation].Status, [Retention & Graduation].HcFROM [Retention & Graduation]GROUP BY [Retention & Graduation].YearPIVOT [Retention & Graduation].[STATUS]
