Question on querie for a sum

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
 
G

Guest

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.
 
Top