多条件交叉报表求教

先联合

SELECT Yw_CAR.事件编号, Yw_CAR.所属单位 as DEP, Yw_CAR.importdt,"CAR" as Type
FROM Yw_CAR
union all 
SELECT Yw_MAN.事件编号, Yw_MAN.所属单位, Yw_MAN.importdt,"MAN"
FROM Yw_MAN
union all
SELECT Yw_POWER.事件编号, Yw_POWER.所属单位, Yw_POWER.importdt,"POWER"
FROM Yw_POWER
UNION ALL SELECT Yw_UPS.事件编号, Yw_UPS.所属单位, Yw_UPS.importdt,"UPS"
FROM Yw_UPS;

TRANSFORM Count(联合查询.importdt) AS importdt之计数
SELECT 联合查询.事件编号, 联合查询.DEP, Sum([importdt之计数]) AS total
FROM 联合查询
GROUP BY 联合查询.事件编号, 联合查询.DEP
PIVOT 联合查询.type;