leinad31;
hi,please help.when i run the query have error appear.
this is my current code:
Code:strsql = "UPDATE OverTime " & _ "Set OverTime.match=1 " & _ "FROM OverTime INNER JOIN Attendance " & _ "ON OverTime.overtimedate = Attendance.overtimedate " & _ "And OverTime.employeeno = Attendance.employeeno " & _ "And datediff('n',Overtime.TimeFrom,Attendance.Time)=0"




Reply With Quote