- Create a make-table query using Union Query as Data Source, run it and create the output table, say tblReport.
- Design the Report using tblReport as Record Source or if you need further filtering the records from tblReport then create a Select Query and use it as report source.
- Open the Report in PrintPreview.
Step 1 & 3 must be repeated every time the report source data changes in the Union Query. Running these two actions manually every time is not advisable.
These two actions (1. opening the make-table Query, 2. Opening the Report) can be put in a macro (sample image of a macro is attached) and run the macro from a Command Button Click Event Procedure on the Form, whenever the report source data changes.
In fact you can put two command buttons on the Form, one for re-running the report through the macro, and another one to open the existing report directly in PrintPreview mode.