I am wondering whether it is possible to reset DSum back to 0 after it reaches 1,000,000.
Technically, the DSum will calculate for me the running total for Total Count and will then reset back to 0 when Total Count is 1,000,000.
I am wondering whether it is possible to reset DSum back to 0 after it reaches 1,000,000.
Technically, the DSum will calculate for me the running total for Total Count and will then reset back to 0 when Total Count is 1,000,000.
Yes, use modulus:
or directly in the ControlSource: