brucevde:
hi,i try the method from your guide.but have error message appear
![]()
this is the current code:
please help!Code:While Not rs.EOF If IsNull(rs("OtHours").Value) Then total = total + 0 Else total = total + rs("OtHours").Value End If rs.MoveNext Wend rs.MoveFirst




Reply With Quote