I am running a group of queries in Access 2010 to sort through records in a table into a work center roster for a given facility. For now, I am using the first query to pull the records just for a given facility. Then, referencing that query, I pull another to get Section A Shift 1 from that facility, Section A Shift 2, and Section A Shift 3, and sometimes a crosstab query to count assigned rank for each shift. These form the foundation for sub-reports on the facility roster. I am trying to speed up processing of this report, as this is taking much longer than my previous version that did the same function, but had fewer possible sections. As it is more comprehensive, this report includes some sub-reports that will not have any data, and this seems to be slowing things down. I read yesterday about coding a cancel event on sub-reports with no data, and will try that, but wanted to understand if Access queries would run faster if I saved the first query I use to pull records just for a given facility back as a temp table, and had all subsequent queries for this report reference the temp table. When subsequent queries run off the first query, does Access re-run the first query going through all records every time, or is that first query effectively only ran once? If so, I would not expect any performance advantage of referencing subsequent queries from the initial query, or a temp table. Suggestions?