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.
Code:
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.