Take that recordset and use it to create a new table (a temporary one) in the local Access database.<BR>3. Close the recordset.<BR>4. Run my report off the new temporary table<BR>5.

Temp tables persist until then connection closes, so you don't have to do it all in one query.<BR><BR>Alternately, try collapsing your queries and eliminate the whole idea of a temp table.

Additional Options --o The path to the output SQL file. Defaults to the director you call the command in. --overwrite: Allow overwriting the output file if it exists. --table_name: Specify the name of ...

Welcome to the Temporary Tables, Views and CTEs lab! In this lab, you will be working with the Sakila database on movie rentals. The goal of this lab is to help you practice and gain proficiency in ...