I have a Query which creates a Report. The query data is provided by dropdowns from a Form.
Different groups of people need different views (I currently have 3 queries which produce 3 reports which have the exact format). So far I have duplicated the query and the reports depending on the selection made from the form. Some selection may be left empty (no slection).
I’m sure I can reduce all the duplications however I don’t know how.
Basically I would like selection to be made in the form to produce one report and not 3 which is the case now.
Please find attached a sample file of the queries I have used.
Your help you be greatly appreciated.