How to only return rows with missing data in any columns?

[MsAxes]

Greetings - I have a data table (real table has up to 30 columns & up to 10k records) where I am only interested in keeping the rows that where any column has no value. I have a delete query (see SQL below) that returns a data type mismatch in criteria expression but I can't see why.

SELECT Data.Customer_Type, Data.Name, Data.Open_Date, Data.Balance, Data.Account_Num, Data.Test_2, Data.Test_3, Data.Test_4FROM Data
WHERE (Data.Customer_Type<>"" And Data.Name<>"" And Data.Open_Date<>"" And Data.Balance<>"" And Data.Account_Num<>"" And Data.Test_2<>"" And Data.Test_3<>"" And Data.Test_4<>"");

Can someone take a look and let me know what I'm missing?



A successful query should only keep John Doe and Jane Sow. Other rows should be removed because no columns are missing data.

I just realized that I did not save the query as a 'Delete' query - I test out under 'Select' before I switch query type.

[MsAxes]

Just figured it out - the non 'Text' data types required Is Not Null instead of <>"".