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
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.
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.
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.
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.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for