To get a sum

[Les]

I need to have a very big table of figures that i need to
get totals for, for a certain criteria.
So what i have done is to do a query to get the correct
information and the first column is 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 ?

 

[Adrian Jansen]

Do the queries themselves take a long time to run, or just the form load ?
IE run the queries by themselves, and time that. Then run them from the
form.
How 'very large' is very large ?

If the queries run slow, there is probably not much you can do, apart from
selecting only just the minimum data you need.

If the form runs slow, check that you are not loading a large recordset -
restrict the output to just the data you actually need.

For a further list of things to check look at:

http://www.granite.ab.ca/access/performancefaq.htm

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control