replacing DSUM with VB function

  • Thread starter Thread starter Helmut Glänzer
  • Start date 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!!
 
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.
 
Back
Top