Delete row (Access 2000)

Topic

New Reply

How can i delete a row in the table tblClinets where the CompanyName is missing ? I get a syntax error in the following comand :
Dim StrSQL As String
StrSQL = “DELETE TblClients.* FROM TblClients ” & _
“WHERE TblClients.CompanyName = “””
DoCmd.RunSQL StrSQL

Reply | Quote

Replies

Try

…
“WHERE TblClients.CompanyName Is Null”
…

Reply | Quote

Thank you Hans, it works awesome !

Reply | Quote