Delete Where ID field is Empty

[hext2003]

I have a table with several row where

Dim SQL1 As String
SQL1 = " DELETE * From cust Where [contract] = ??? "
DoCmd.RunSQL SQL1

Contract has a 1, 2 or nothing in it. i want to keep all the 1's and 2's but delete out the ones with nothing.

I have tried NULL I have try "" and '' and <> 1 but can't get it to work.

 

[PWise]

Dim SQL1 As String
SQL1 = " DELETE * From cust Where [contract] is null "
DoCmd.RunSQL SQL1

 

[hext2003]

THANK YOU!