SQL top udpate date to now when date is Null

[nmapeso]

What the correct syntax on this one? So far its not working at all. I'm trying to update a table (maintblBankruptcy) namefiels (DateESent) to now where DateESent is Null.

Dim SQL As String
SQL = "UPDATE maintblBankruptcy" & "SET maintblBankruptcy.DateESent = Now" & _
"WHERE [maintblBankruptcy.DateESent] is Null"
DoCmd.RunSQL SQL

Thanks for all your help. I'm still learning all this SQL statement.

 

[PHV]

SQL = "UPDATE maintblBankruptcy SET DateESent=Now()" & _
" WHERE DateESent Is Null"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886