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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUM in a UNION query 2
query showing - number and + total 1
Access Dcount (multiple criteria) 3
Combine Duplicates in Query 0
Calculations in a Sum Query 2
Running Sum in Query for Count Field 0
Sum a count total 2
Union query not displaying select statement 1

Back
Top