Stop running sum(Over All) when customer change

Dear All

I hv report based on tblTransaction which contains many customers with their
transactions by date wise. I grouped report on CustomerID sub Group by
Fromat(trnDate,�MMM-YY�) to get monthly transactions for each customer. I
made calculated field to obtained closing balance with running sum over Group.
I want to make the Running sum – over all but when customers is changing it
must stop and start again, by default it will give running sum of all the
customer, exactly this I don’t want. Any idea to stopped or make running sum
based on customer when month is changing it should carry on so I will get
uptodate balance of each customer?
Thanks in advance

Wahab wrote:
I hv report based on tblTransaction which contains many customers with their
transactions by date wise. I grouped report on CustomerID sub Group by
Fromat(trnDate,”MMM-YY”) to get monthly transactions for each customer. I
made calculated field to obtained closing balance with running sum over Group.
I want to make the Running sum – over all but when customers is changing it
must stop and start again, by default it will give running sum of all the
customer, exactly this I don’t want. Any idea to stopped or make running sum
based on customer when month is changing it should carry on so I will get
uptodate balance of each customer?


You need two RunningSun text boxes. Add a text box to the
month group footer section. Set its expression to
={first run sum text box}
and set its RuningSum property to Over Gtoup. Because it is
in a group footer section it will keep going until the next
higher level group changes.

--
Marsh
MVP [MS Access]

Thanks Mr. Marshall,
It's very easy.
Once again thanks.

"Marshall Barton" wrote:

Wahab wrote:
I hv report based on tblTransaction which contains many customers with their
transactions by date wise. I grouped report on CustomerID sub Group by
Fromat(trnDate,�MMM-YY�) to get monthly transactions for each customer. I
made calculated field to obtained closing balance with running sum over Group.
I want to make the Running sum – over all but when customers is changing it
must stop and start again, by default it will give running sum of all the
customer, exactly this I don’t want. Any idea to stopped or make running sum
based on customer when month is changing it should carry on so I will get
uptodate balance of each customer?


You need two RunningSun text boxes. Add a text box to the
month group footer section. Set its expression to
={first run sum text box}
and set its RuningSum property to Over Gtoup. Because it is
in a group footer section it will keep going until the next
higher level group changes.

--
Marsh
MVP [MS Access]
.