I'm late in on this. I liked the combine all into one table idea, temp or perm, both are possable.
Suggestion for the future, not that it is going to solve the current problem. When I reached that brick wall in getting Access to do what I wanted it to do I learned SQL (Structured Query Language). You can make a database sing with SQL. Experiment, in your QBE window do menu|views|sql view. Even reading through the crazy text can sometimes help, copy and paste to notepad for further study. When closing save design changes NO!
Good luck! Roy