DSUM Criteria Help (1 Viewer)

[feinj]

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.

 

[pbaldy]

Along the lines of:

"ID <=" & [ID] & " AND Item = " & [Item]

presuming Item is a numeric field.

 

[feinj]

Item is a Text Field.

 

[pbaldy]

Try

"ID <=" & [ID] & " AND Item = '" & [Item] & "'"

 

[feinj]

Thanks Paul. That worked really great.

Jerry

 

[pbaldy]

Happy to help Jerry!