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...
I'm also anxious to learn how to do this as well. I have an executive report that is compiled of 20 different pages (call them sub-reports?). I would like to use Access to generate each of the 20 pages (currently seperate reports in Access, due to varying layout and content on each page) for...