Criteria is NULL

[Praveen Manne]

Hi

I have a query, which will delete the whole record if the SSN = NULL

this is the query

Delete tblname.LN, tblname.FN from tblName where tblName.SSN = Null;

This statement is not working. Is there any wrong in the above statement ?

Please Help

Thanks
Praveen Manne

 

[fredg]

Hi

I have a query, which will delete the whole record if the SSN = NULL

this is the query

Delete tblname.LN, tblname.FN from tblName where tblName.SSN = Null;

This statement is not working. Is there any wrong in the above statement ?

Please Help

Thanks
Praveen Manne

Delete tblname.LN, tblname.FN from tblName where tblName.SSN Is Null;

 

[Van T. Dinh]

You cannot use the equal operator with Null since the
expression:

Null (value) = Null

will return Null, NOT True.

Use ...WHERE tblName.SSN IS Null

HTH
Van T. Dinh
MVP (Access)

 

[Steve Schapel]

Praveen,

Try it like this...
DELETE * FROM tblName WHERE SSN Is Null

 

[Praveen Manne]

Thank you guys,

Thanks for your help. It woked !

Praveen Manne