如下图: 求实际工时
各位帮忙改下代码:谢谢...
Dim i As Integer
Dim s As Variant
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
rs.CursorLocation = adUseClient
rs.CursorType = adOpenKeyset
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Haiyang\桌面\
新建 Microsoft Office Access 应用程序.mdb;Persist Security Info=False"
rs.Open "select * from 123", cnn, adOpenKeyset, adLockOptimistic
For i = 1 To rs.RecordCount
s = DateDiff(s, Trim(rs.Fields("开工时间")), Trim(rs.Fields("完工时间")))
rs.Fields("实际工时") = s
rs.MoveNext
Next i
rs.Update
rs.Close
cnn.Close