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!

You cannot post new topics in this forumYou cannot reply to topics in this forumYou cannot delete your posts in this forumYou cannot edit your posts in this forumYou cannot create polls in this forumYou cannot vote in polls in this forum