Hi,
I am trying to build a database to collect Field Safety review data from several distinct Units (over 100) grouped by Divisions (over 20)
The main report has to include all Units under a specific Division on one page and the rows are the questions(21) and on the columns each Unit compliance (Yes/No). An example below
Unit 1 Unit2 Unit3 Unit4 Question 1 Yes No Yes Yes Question 2 No Yes No No Question 3 No No Yes Yes Question 4 Yes Yes No Yes Question 5 Yes Yes No No Question 6 Yes No Yes No Question 7 No No Yes Yes Question 8 Yes Yes No Yes Question 9 No No Yes No
So far I only know to make specific queries for each Unit and Sub-reports based on those queries under the main Report. Is there a better way to have this report without having to build 100 queries?