Difficulty calculating daily running total

[Mildleave]

I was able to compute running total using the DSum Function.


However, I have been finding it challenging to compute daily running total (for instance; I want to be able to know sales transaction total for each day and then I would like the running total to reset to zero the following day).
NB: The "Date of Transaction" is the criteria field.
Kindly assist with solution.

Thank you in anticipation.

[June7]

You need to calculate running sum over group.

This is easiest to do with RunningSum property of textbox on report along with report Sorting & Grouping.

Post your attempted query statement.