Are there any results for the 2016 table using the WHERE filter if its run on its own?
What happens if you do this in 2 stages?
1. Create qryUnion with no filters
2. Create another query filtering qryUnion
Also, as possibly implied in post #1 table is the plan to combine all 3 tables into one?