DSUM Function

[Brennan]

Quick Question - I am using the DSUM function to pull data from a table into
a report in access 2003. Can you use the DSUM function to pull data from a
query?

Also, I noticed that there is some lag time when using the DSUM function -
is there a faster way to pull data from a large data table? Thanks for your
help.

Brennan

 

[John Spencer]

Yes, you can use DSum against a query - usually. If the query is a
parameter query then where you input the value when the query executes
then no.

If you are only returning one to a few records then Dsum should be fast
enough. If you need to pull the sum for a lot of records then a
subquery or a separate query that gets the sums is going to improve
performance. If you run a separate query that gets the sums you want
then you can join it to your tables in your main query as if the
separate query were a table.


'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================