I have an Access file that has 18 different queries I created, all of which have been created to get a count of records.
I would like to setup a form that can be opened to see a "digest view" of all these numbers, but then clicking on the listed item would bring up the detailed report showing the breakdown of the count between each category.
Everything I have read says to create sub-forms, but every sub-form I create makes the entire form look big and clunky when I only need a little space for each data point.
Any and all input is greatly appreciated!