Running Total in a Query (A97 SR-2)

Topic

New Reply

I am trying to calculate a running sum in a query as listed below.

Amount RunningTotal
1 1
2 3
3 6
4 10

I have tried using DSum as follows, but it results in the RunningTotal calculation being 10 in each row.

RunningTotal: DSum(“[Amount]”,”tblData”)

Reply | Quote

Replies

You need a unique key by which your data are ordered to do this.
If your key field is named ID and the field you want to sum is Amount, the expression for Running Total would become

DSum(“Amount”, “tblData”, “ID<=" & [ID])

This means that DSum is taken over all records with an ID up to and including the ID in the current record.

Reply | Quote

Thank you very much! I already had the ID field in the table and your solution worked great.

Reply | Quote