I have done stuff like this before successfully.
But I would question the 26 queries. What is the difference between all the queries? Are they subtle?
If they are, I have used solutions to this that use one Form, two Queries, and one Report.
Basically, I have a Query that has all possible records/fields that I may need for my Report.
I then have a Form where users make criteria selections (for what they want to see on the Report).
Then, when they click the button, I have VBA code that creates the SQL code it needs from the first query and applies it to the second Query (so the second Query is dynamic and built on-the-fly).
Then the Report uses the second Query as its Record Source.
The big advantage here is if you ever needed to update the underlying query for any reason, you only need to update one and not 26.
And creating the SQL code for the query on-the-fly is really not as hard as it seems. If you can build an example using Query Builder, just switch to SQL View and you can see exactly what the SQL code you need to build looks like. And you are really only having to create the criteria part, as the first part of the SQL query is always the same, i.e.
Code:
SELECT [Query1].*
FROM [Query1]
WHERE ...