D
DS
I'm trying to Update a blank record with this statement. It's blank but
I'm not sure if it's null. It's a Time field and a Date Field. This
statement isn't Updating anything. Any help appreciated.
Thanks
DS
Dim LOGSQL As String
LOGSQL = "UPDATE tblTimeLog SET tblTimeLog.LogTimeOut =
Time(),tblTimeLog.LogDateOut = Date() " & _
"WHERE tblTimeLog.LogTimeOut = Null " & _
"AND tblTimeLog.LogDateOut = Null;"
DoCmd.RunSQL (LOGSQL)
I'm not sure if it's null. It's a Time field and a Date Field. This
statement isn't Updating anything. Any help appreciated.
Thanks
DS
Dim LOGSQL As String
LOGSQL = "UPDATE tblTimeLog SET tblTimeLog.LogTimeOut =
Time(),tblTimeLog.LogDateOut = Date() " & _
"WHERE tblTimeLog.LogTimeOut = Null " & _
"AND tblTimeLog.LogDateOut = Null;"
DoCmd.RunSQL (LOGSQL)