How to set up a quoted blank in an SQL ststement
I want to delete records in a table whose Field3 is either blank, "", or " ".
The SQL view in a delete query is
DELETE Table1.*
FROM Table1
WHERE (((Table1.Field3)=(Chr(34) & " " & Chr(34))));
But This does not work in an Sql definition in VBA, i.e,
Dim strSql As String
StrSql = "DELETE Table1.* FROM Table1 WHERE (((Table1.Field3)=(Chr(34) & " " & Chr(34))));"
DoCmd.Run Sql strSql
doesn't recognize the quoted blank (" "). I've tried several Chr(34)'s and &'s, but my flailing attenmpts do not work.??