replacing DSUM with VB function

  • Thread starter Helmut Glänzer
  • Start date
H

Helmut Glänzer

Hi,
there was a posting recently (6 weeks?) on how DSUM could be replaced by a
VB function to achieve linear performance with large data sets where the
running sum needs to be built. Unfortunately I cannot find this posting
anymore.
The task sounds easy enough but if you do not know how to perform it .. .
Basically you would want to keep the running sum number from the last
processed record, add the value from the current record and update it. How
can this be done?

Thx!!
 
V

Van T. Dinh

Not sure of the post you mentioned but it sounds like creating a Recordset
and then traversing from the first to the last Record should do.

Check Access VB for Recordset.
 

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

Dsum and Dmax with structured references 1
How to replace DSUMs killing network performance? 1
Access 2003 Query: Dsum function Help 1
Sub-Query 2
DSum and date as criteria 3
Converting Word macros 0
DSUM Not Very Convenient 2
not counting breaks, but numbering them: 1,2,3,4,5,... 1

Top