Results 1 to 9 of 9

Thread: compare Time between 2 table

Hybrid View

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Nov 2006
    Posts
    584

    Re: compare Time between 2 table

    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"
    Attached Images Attached Images  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width