1-12月的工资表,我用SQL语句汇总,但出勤天数只计数不求和,不知道是什么原因?
sheet1-12 是从别的工作簿手动复制过来的,应领工资和实领工资有简单公式
具体SQL语句是
SELECT * FROM [Sheet1$] UNION ALL
SELECT * FROM [Sheet2$] UNION ALL
SELECT * FROM [Sheet3$] UNION ALL
SELECT * FROM [Sheet4$] UNION ALL
SELECT * FROM [Sheet5$] UNION ALL
SELECT * FROM [Sheet6$] UNION ALL
SELECT * FROM [Sheet7$] UNION ALL
SELECT * FROM [Sheet8$] UNION ALL
SELECT * FROM [Sheet9$] UNION ALL
SELECT * FROM [Sheet10$] UNION ALL
SELECT * FROM [Sheet11$] UNION ALL
SELECT * FROM [Sheet12$]