amorosik
Member
- Local time
- Today, 14:52
- Joined
- Apr 18, 2020
- Messages
- 438
For example, in a table CUSTOMERS there is 5 column, NAME, SURNAME, ADDRESS, CITY, EMAIL
The CUSTOMERS table already contains thousands of rows
But the CITY field has never been valued on any line
Here, the question is: how to find the columns within a table, which have never been filled in?
Not a vba loop that scrolls through all the columns and tests individually, but I mean a single query that returns me the columns of the table in which not even a value has been stored on all the rows present in the table
The CUSTOMERS table already contains thousands of rows
But the CITY field has never been valued on any line
Here, the question is: how to find the columns within a table, which have never been filled in?
Not a vba loop that scrolls through all the columns and tests individually, but I mean a single query that returns me the columns of the table in which not even a value has been stored on all the rows present in the table
Last edited: