Hi

I have been watching your videos and these are amazing!

I wanted to know if its possible to have a query that displays ONLY the fields or columns which are empty.

for example I want to create a table which has AnalysisID, CustomerID, and Test1, Test2, Test3 ---> Test50

However each customer requires different tests. example Customer 1, might have Test1 and Test5, while Customer2 might have Test1, Test2, Test7.

I wanted to be able to query columns that are NOT NULL for that specific customer, so only their column/Field with the analysis result will be displayed, and then I can use that query in a report.

Thank you in advance. I know this might be a long shot.

Kind Regards
Raman