Complex Queries: Cycle times

[Guest]

Good day!
I'm trying to figure out how to cut the cycle time of running a query. Here
is why I THINK I can cut the cycle time, but I'm not sure. I'm just
wondering if anyone has encountered this situation before, and if you think
it is possible:

I'm running Query B off of Query A results. Query A is run from a set of
linked tables. The data for Query A only changes on a daily basis, whereas
Query B's main purpose is to provide a report based upon a single variable.
This process is run 37 times on a particular day, through the use of a macro.
This process currently takes 29 minutes to complete. Here is where I think
a lot of time is wasted:

Since Query B runs off of Query A, every time Query B is run, Query A is
re-run? So, two queries must process before providing a result. Since the
data for Query A only changes on a daily basis, would it speed things up to
export Query A as a table and then run Query B from that specific table?

Thanks for your time and your help!

 

[MGFoster]

Yes, especially if you then indexed some columns in the new table that
will be used in Query B's criteria (WHERE clause).

 

[Guest]

Thank you MGFoster!

Yes, especially if you then indexed some columns in the new table that
will be used in Query B's criteria (WHERE clause).