Question on querie for a sum

  • Thread starter Thread starter Les
  • Start date Start date
L

Les

I have a very big table of figures that i need to
get totals for, on certain criteria.
So what i have created a query to get the correct
information and the first column is a count, i then pull
that query into another query to get a sum of the count,
however this is proving to take very long when loading the
form to get the results displayed.
The question is, is there a better way to do this ?

Any help is appreciated
 
You could make a table from the results of the first
query, and use that in your second query. Otherwise, when
you run your 2nd query, both queries are running.
 
Back
Top