If NULL NOT SHOW FOR Multiple Columns (VBA)

[GCLIFTON]

Need help. I have roughly 30 fields in a table. I want to in a query or in a report a vba that would do the following. I am not sure which way is best

First in the Scope Column give me all that value that = 90. In which I know in the Query Design View is "90". Correct?

but second,

If any of the columns starting with Entry Door going to the right (Which is 30+) = Good show me that data but exclude any of the 30+ columns that does not have "Good" Meaning do not show.
So for the example in a query once it has run the only columns that would show in the example below would be. Combine, Building Number, Unit Type, Verified, Status, Hand, Scope and Kitchen Floor for only 1936-2 and 1936-3.

[ssanfu]

It looks like your table design is what is known as "Committing Spreadsheet". Excel spreadsheets are short and wide. Access tables are tall and narrow.

You have field names like "Entry Door", "Kitchen Cabinet", "Kitchen Counters", "Kitchen Sink", "Kitchen Faucet", "Kitchen Floor"; these are actually data.

My first suggestion would be to normalize your table structure.

Second option: You might look at the code at http://www.allenbrowne.com/ser-62code.html for building a criteria clause. You could use this technique to create a query (in code) and modify the SQL of the saved query.

[GCLIFTON]

Not understanding when you say Normalize the table Structure. This table is create from a form that has each column. Per what you select it fills out the table that you see. From this data i am running queries and reports.

and i will go deeper in the second option as well. Question, per my statement i just mention would the Second option still apply.

[orange]

Normalization

[GCLIFTON]

Normalization yes. This data was a test in which you are correct and picked up that was from and excel file that was not completely fill out. Currently i have a form that files out each cell in the database sheet. It is set that you can not go to the next without applying something to the previous. I now know this process of doing things in Access is call Normalization. Thank you for that information and also thanks for Access Functions, between the documents i can see how it can make a lot things easier.