Search results

Yeah - I see where you're coming from. The results would be a mix, and in some cases every field could be returned (Like the Tim example). What I'm trying to do is quickly identifiy gaps where data was not entered for a record.

Let’s say I had a table like below, and I only want to select the name and any field which was blank / null name, field1, field2, field3, field4, field5, field6, field7 For example, if the name was ‘John’ and field1, 2, and 6 were blank I would want my results to be Name Field1 Field2...