I have a database that contains approximately 9 queries of which 2 are pass through queries, 1 is a cross tab query and 6 are queries running off one of the pass throughs and the cross tab. I have created a macro to transfer datat sheets to one excell file. The problem I am running into is that when I run the macro, I believe each time it runs a particular querie, it reruns the pass throughs and cross tab...taking a very long time to do so. Are there any suggestions on having a teporary table house the results of the passthroughs so the other 6 can run off the table. Then, once the macro is complete, deleting the table or leaving the table and deleting the records housed on it. Any help or direction or help would be appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
querying off pass through query 1
- Thread starter keden
- Start date
-
1
- #2
Make a select pass-through query for the particular records. From that query, create a make-table query which will be the temporary table that the crosstab and other queries are from.
To recreate the temporary table, simply rerun the make-table query rather than deleting the records from it and appending the pass-through records again. The make-table is much faster than the delete/append option.
To recreate the temporary table, simply rerun the make-table query rather than deleting the records from it and appending the pass-through records again. The make-table is much faster than the delete/append option.
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Question