1,216
社区成员
发帖
与我相关
我的任务
分享
Adodc2.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path & "\考勤.mdb;Persist Security Info=False"
Adodc2.RecordSource = "SELECT 序号,姓名,SUM(加班小计) as 工作日加班 FROM 考勤 WHERE (right(星期,1)<>'六' and right(星期,1)<>'日') GROUP BY 序号,姓名"
Adodc2.Refresh
Set DataGrid2.DataSource = Adodc2
Adodc2.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path & "\考勤.mdb;Persist Security Info=False"
Adodc2.RecordSource = "SELECT 序号,姓名,SUM(加班小计) as 双休加班 FROM 考勤 WHERE right(星期,1)='六' or right(星期,1)='日' GROUP BY 序号,姓名"
Adodc2.Refresh
Set DataGrid2.DataSource = Adodc2
Adodc2.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path & "\考勤.mdb;Persist Security Info=False"
Adodc2.RecordSource = "SELECT 序号,姓名,SUM(加班小计) as 加班小计,SUM(休假) as 休假,SUM(早班时间) as 早班时间,SUM(中班时间) as 中班时间,SUM(夜班时间) as 夜班时间 FROM 考勤 GROUP BY 序号,姓名"
Adodc2.Refresh
Set DataGrid2.DataSource = Adodc2
SELECT C.序号, C.姓名, 加班合计, 休假合计, 早班合计, 中班合计, 夜班合计, 工作日加班, 双休加班
FROM(
SELECT A.序号, A.姓名, 加班合计, 休假合计, 早班合计, 中班合计, 夜班合计, 工作日加班
FROM (SELECT 序号, 姓名, SUM(加班小计) AS 加班合计, SUM(休假) AS 休假合计, SUM(早班时间) AS 早班合计, SUM(中班时间) AS 中班合计, SUM(夜班时间) AS 夜班合计 FROM 考勤 GROUP BY 序号, 姓名) AS A LEFT JOIN (SELECT 序号, 姓名, SUM(加班小计) AS 工作日加班 FROM 考勤 WHERE (right(星期,1)<>'六' and right(星期,1)<>'日') GROUP BY 序号, 姓名) AS B ON (A.序号=B.序号) AND (A.姓名=B.姓名)
) AS C
LEFT JOIN (SELECT 序号, 姓名, SUM(加班小计) AS 双休加班 FROM 考勤 WHERE right(星期,1)='六' or right(星期,1)='日'GROUP BY 序号, 姓名) AS D ON (C.序号=D.序号) AND (C.姓名=D.姓名)