Is there a better way to do this?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 45 queries (that perform calculations from info in various but very
similar tables) that I am going to query to SUM it all together. However, as
you might imagine this takes forever. I have already reduced the subqueries
to extracting only what is needed for the master query, but is there anything
else I can do to decrease the processing time?
 
A good guess would be for you to look at the design of your tables. 45
queries to sum all your data for one form or report seriously points to
flaws in the design of your tables.
 
Back
Top