Search results

I'm baffled by how to generate a query (preferably without SQL or VBA) that will generate the results I'm looking for. I'm attaching an access file to help show what I'm trying to do. Scenario: - collecting data on various conditions of a building - the inspector is provided a list of items...