How to Create a Running Sum in an Access Query

Written by marlon trotsky
  • Share
  • Tweet
  • Share
  • Email

In Access, a running sum is a query that is gathered record-to-record across a group or an entire report. That is, it allows you to find the total of a specific group of variables, such as money, integers or percentages. To create and run this query, you should enter DSum() function, which tells Access to create a running sum over a group.

Skill level:

Other People Are Reading


  1. 1

    Open the desired database and create a new select query. Add the "Orders" table. Under the "Design" tab, click "Totals" under the "Show/Hide" group.

  2. 2

    Go to the first column of the query-design grid and enter the variable by which you want the field to be grouped in the "Field" box. Enter "Group By" into the "Total" box and type "Yes" into the "Show" box.

  3. 3

    Proceed to the query-design grid's second column and enter the variable that you want totalled into the "Field" box. Type "Sum" into the "Total" box and once again type "Yes" into the "Show" box.

  4. 4

    Type the DSum() function into the "Field" box of the third column. The function should follow this format:

    RunTot: Format(DSum("variable","variable","[variable]<="& [variable] & ""), "format for the field")

    Enter "Expression" into the "Total" box and "Yes" into the "Show" box. Run the query and look at the "RunTot" field for the running sum.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.