Recent content by eoinew

arnelgp - Thats exactly it! Amazing. There is another condition/calculation I need to add to this. When the 'EORisk' column of the previous record is >=0 the RunningTotal needs to reset (which is done, thank you), but also the 'Number_of_Months' column needs to decrease by the value in the...

In the meantime I worked on the attached - nearly there but it is generating an error due to no 'EORisk' column in the EO_RIsk query I think.

Hey arnelgp, I tried amending so that the query runs off a sum of the Total_On_Hand query instead of the Daily_Inventory_Report table, as I only want one row per Lot_Code in the final query result. I think the ID field is causing a bug in Module1 but I'm out of my depth as to figure out a...

That's it! However, I updated the EORisk column to calculate from the new query using the new RunningTotal column (EORisk: [RunningTotal]-[Forecast_Usage] from Query1). The original EORisk was an incorrect calc due to using the old RunningTotal column. See updated file attached. Thank you...

Thanks theDBguy arnelgp! Really impressive arnelgp! I implemented your solution arnelgp, but the 'EORisk' is not a field in the table, its a query field, so ran into a bug. I've attached some sample data that will give you a better understanding. There's also a join with a 'Forecasts' table...

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 AND T1.SKU_ID = SKU_ID) I want to add a condition so that this running total stops and resets when the...