asked
Retreive column names for Blank rows
How to retrieve the blank row column names from a table.Need to provide a list of all column names which have blank cell values group by each row. [Additional info] I have 24 tables each with 62 rows ( field "name" with 62 unique names is the Primary Key) and 25-50 columns .Now for each row (or field "name") I want to retrieve the column name which has a blank value .I can use "is null" function but the problem is, it has to be done for each column,so I was wondering if I can get some help to retrieve the blank cells from all columns at once. Thank you very much.
I think you need to give us some sort of example of what you mean so that we understand your problem better
9 People are following this question.
