Need help creating a DSUM Expression that will summarize quantities in a Domain where the Item is the same in the Item column.
The Table being used as the domain contains several items, but I want a Running Sum for each item in the Domain, assuming they are all sorted in order of item and quantity ascending. The Domain Table has consecutive ID Numbers.
RunningSum: Abs(DSum("OpenQty","Shared Responsibility SO Lines Tbl","ID <=" & [ID]))
The expression above summarizes the OpenQty column for all items. I want to restart the sum in the query when the item changes in the item column
Please give me some your help.
The Table being used as the domain contains several items, but I want a Running Sum for each item in the Domain, assuming they are all sorted in order of item and quantity ascending. The Domain Table has consecutive ID Numbers.
RunningSum: Abs(DSum("OpenQty","Shared Responsibility SO Lines Tbl","ID <=" & [ID]))
The expression above summarizes the OpenQty column for all items. I want to restart the sum in the query when the item changes in the item column
Please give me some your help.