delete where field is empty

[PortalMelt]

Trying to use a SQL statement (within a macro) to delete a row if a field is empty.

This isn't working.
DELETE FROM PM0900Aa WHERE (((PM0900Aa.[TEAM])=""));

No errors, just doesn't do the job.

Seems to be deleting data from just that field not deleting the whole row (found this when I tried matching some other data).

Where am I going wrong?

Jeff

 

[Pat Hartman]

DELETE * FROM PM0900Aa WHERE PM0900Aa.[TEAM] Is Null;