My query resets the DSum running total (RT) when the ITEM_ID changes, but it doesn't reset when the LOC_ID changes like in the 3rd record below where it's RT should show as 193. I have also tried using Net Forecast Week in my trials and errors. It took me a long time to get this far with all the syntax and single/double quotes.
RT: DSum("[NF Qty]","Net Forecast by Item by Week","[Auto ID]<=" & [Auto ID] & " And [ITEM_ID]='" & [ITEM_ID] & "'" And [LOC_ID]='" & [LOC_ID] & "'")
ITEM_ID LOC_ID Net Forecast Week NF Qty RT 87-635F263 BN 201652 692 34418 87-635F263 BN 201653 693 35111 87-635F263 JD 201606 193 35304
Thanks for your help!
Tom