strSQL Delete

[HS_1]

Can somebody tell me what I am doing wrong? I am trying to run delete statement where Pending_Notes = "". (Is null) doesn't work.
Thanks

Private Sub btnHistory_Click()
Dim strSQL As String
strSQL = "DELETE * FROM [tblHistory]" & _


"WHERE [Pending_Notes] ='""'"
CurrentDb.Execute strSQL

[andy49]

Space before where


Sent from my iPhone using Tapatalk

[ranman256]

build a query from this sql.
it will give you error messages.

But usu its
WHERE [Pending_Notes] is null

[HS_1]

I have added space as you suggested but still get syntax error 3075.
I also run simple qry with 'is null' as ranman256 suggested but no record was selected, only "" works.
DELETE tblHistory.[Pending_Notes], *
FROM tblHistory
WHERE (((tblHistory.[Pending_Notes])=""));

My problem is I don't know how to change delete query to code and not get an error?

[andy49]

DELETE * FROM [tblHistory]" & _
 " WHERE [Pending_Notes] is null));"