I know I have asked alot of questions about this but I am working my way through trying to become a better access report builder.  
I have discovered that when I run the report based on the select query that is based on the pass through query, the pass through query is run also and my data in the report is up to date.  
 
Is there a down side to this method, as opposed to make table from the pass through and select query based on the make table?
I have managed to automate the pass through and make table on opening the database, but the make table takes a long time to execute.  Is this usual?