The criteria make a reference to the same column that contains the duplicate value i.e. This is happening because of the way the criteria has been written in the DSUM () function. What we really need is that DSUM should add the same amount to the previous total regardless of whether or not they are equal. On running the query on the table with duplicate values, you’ll get:Īs you can see, the DSUM () will return the same result for both the product instead of calculating a cumulative sum or running total. Let’s say that product 14 and product 15 now have equal values (i.e.

The above formula will NOT work when there are two products with the same value i.e. RT: DSUM(“”, “”, “>=”&)Īt every record, the DSUM () examines the criteria and returns the sum of all the records that meet the criteria. In this field, create a DSUM() expression as follows:

Add a third field and label it as RunTot.

Then select the field Amount and change the sort order to descending.

Select the field Product in the query design wizard.

Then apply a descending sort on the column amount as shown in the figure below: In order to get the products in descending order, you create a Select query by selecting the two columns (fields) that you need. Let us begin with the 1 st point in the scenario. Running Total with Product Amount in “Descending Order” the sales volume is neither in ascending order nor in descending order. The data you have received is as follows:Īs you can see, there are total 25 products along with their sales volume in dollars (titled ‘Amount’). In short, every time a new record is added, the sale of the new record is added to the sum of all previous records. in the given example, since you are creating a running total you’ll know the total sales made so far every time a new entry is made” “One of the advantages of running total is that it helps you to know the total sales made so far at any point of time i.e.

A better way to understand this is by looking at the example below: Running total is the sum of sequence of numbers in such a way that each new sequence of number is added to the sum of the previous sequence. Create a running total in the given order of products (any random order).

Example of microsoft access report sum