Reset Running Total if another field value of a previous record has a positive value

Hi there,   I am running a query which has a Running Total field as below;   RunningTotal: (SELECT SUM(Total_On_Hand) FROM Daily_Inventory_Report WHERE T1.Shelf_Life_Date >= Shelf_Life_Date AN...