RunningSumInQuery.mdb (beginner)

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

 RunningSumInQuery.mdb 

This sample illustrates how to create a Running Sum in a query.It shows how to:
 1) Create a running sum over the entire table 
or
 2) Create a running sum over a group.  In this case, the group is the OrderID field.
There are two methods shown here: Using a 1) correlated subquery and 2) DSum domain aggregate function.  The correlated subquery
 is the faster method, but it returns a non-updateable recordset.  The Dsum method is slower, but the recordset is updateable.
HOWEVER, it should be noted that against a large dataset, neither method will be very fast!
Documentation included.

Download
Access 2003 (.mdb): uploads/5/RunningSumInQuery2k.zip
Access 2010 (.accdb): uploads/5/RunningSumInQuery2010.zip

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Roger Carlson Members Profile Send Private Message Find Members Posts Add to Buddy List Microsoft MVP Joined: 20 Feb 2008 Status: Offline Points: 269	Post Options Post Reply Quote Roger Carlson Report Post Thanks(0) Quote Reply Topic: RunningSumInQuery.mdb (beginner) Posted: 23 Jun 2016 at 7:01am
	RunningSumInQuery.mdb This sample illustrates how to create a Running Sum in a query. It shows how to: 1) Create a running sum over the entire table or 2) Create a running sum over a group. In this case, the group is the OrderID field. There are two methods shown here: Using a 1) correlated subquery and 2) DSum domain aggregate function. The correlated subquery is the faster method, but it returns a non-updateable recordset. The Dsum method is slower, but the recordset is updateable. HOWEVER, it should be noted that against a large dataset, neither method will be very fast! Documentation included. Download Access 2003 (.mdb): uploads/5/RunningSumInQuery2k.zip Access 2010 (.accdb): uploads/5/RunningSumInQuery2010.zip
	Consider donating $1 per sample downloaded, find out why here.<

Sponsored Links	> Want a good read? Try The Summer of His Life (available on Amazon!)

carlrj Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 31 Dec 2006 Status: Offline Points: 25	Post Options Post Reply Quote carlrj Report Post Thanks(0) Quote Reply Posted: 23 Jun 2016 at 7:04am
	Updated 2010 version
	--Roger Carlson roger.j.carlson@gmail.com