Forum Discussion
eoinew
Nov 30, 2021Copper Contributor
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...
George_Hepworth
Nov 30, 2021Silver Contributor
Any chance of getting a sample accdb to work with. I, for one, often find it difficult to work with abstracted elements like the field shown and screenshots. It's quicker to have real data to work with. Sample data is fine if it reflects the structure and contents of the real data.