My database collects school exam results and one form I use shows how many students got each grade for any particular exam. An example is shown below:
Because of the large quantities of data, the process is currently:
Extract all relevant data to a local table then display results in a form.
However, my Line Manager would like to be able to compare two sets of data so I am thinking of having two tables similar to above set side by side. The user would be able to select both groups by combobox.
Should I use subforms? Or can anyone see a wiser alternative?