Delete record if Material IsNull 1

[vamoose]

Hello, I am importing an Excel 2000 document into Access 2000. The resulting table now has blank records contained within. I am trying to use the following code to delete these blank records:

DoCmd.RunSQL "Delete * from Imported where Material = IsNull"

Or

DoCmd.RunSQL "Delete * from Imported where Material = " & Isnull

But the IsNull does not work, what is the proper way to code this expression if the data field contains no data?

Thank you.

 

[CaptainD]

Try

"Delete * from Imported where Material Is Null"

 

[lewds]

Hi.....

Considering you have a table called Imported and aleast one of those fields is called Material

DoCmd.RunSQL "DELETE * FROM Imported WHERE (([Material] Is Null));"