Hi to all
I have this sql
sSql = "UPDATE GUN_D SET GUND_DATEAPPLICATION = #" & Format(W_GUNL_DATEAPPLICATION, "mm/dd/yyyy") & _
"#, GUND_RELEASEDATE = #" & Format(W_GUNL_RELEASEDATE, "mm/dd/yyyy") & _
"#, GUND_EXPIRYDATE = #" & Format(W_GUNL_EXPIRYDATE, "mm/dd/yyyy") & "# WHERE GUND_ID = " & W_GUND_ID
I want to make a check for this 3 days and if it is empty pass null value.
I have to use the iif statment but after 1 hour :banghead::banghead::banghead: i didn't fount the correct syntax.
Thanks and regards.
I have this sql
sSql = "UPDATE GUN_D SET GUND_DATEAPPLICATION = #" & Format(W_GUNL_DATEAPPLICATION, "mm/dd/yyyy") & _
"#, GUND_RELEASEDATE = #" & Format(W_GUNL_RELEASEDATE, "mm/dd/yyyy") & _
"#, GUND_EXPIRYDATE = #" & Format(W_GUNL_EXPIRYDATE, "mm/dd/yyyy") & "# WHERE GUND_ID = " & W_GUND_ID
I want to make a check for this 3 days and if it is empty pass null value.
I have to use the iif statment but after 1 hour :banghead::banghead::banghead: i didn't fount the correct syntax.
Thanks and regards.