If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Stop running sum(Over All) when customer change
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 dont 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] |
#3
|
|||
|
|||
Stop running sum(Over All) when customer change
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] . |
Thread Tools | |
Display Modes | |
|
|