Criteria is NULL

  • Thread starter Thread starter Praveen Manne
  • Start date Start date
P

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
 
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
Click to expand...

Delete tblname.LN, tblname.FN from tblName where tblName.SSN Is Null;
 
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)
 
Back
Top