DSum

[GuyfromDet]

I am trying to use the Dsum function in a query. The challenge is the running total is the same for each line of data
TTL: DSum("[calc1]","[Client_Rpt]")

The Cacl1 field is what I want it to add

Calc1 RT
$10 $10
$15 $25
$30 $55

Thanks.

[JoeM]

You are missing the Criteria part of your DSUM calculation. Without that, it is going to total ALL records, not do a running sum.
See:
https://support.microsoft.com/en-us/...crosoft-access
https://theaccessbuddy.wordpress.com...m-part-1-of-2/