Need assistance creating a consumption/replenishment report.

Thanks for the reply. This is just a facsimile data set of what I'm actually working with, so dates aren't representative of real dates.  The consumption breakout was a resulting table, not an input.

The real thing I'm looking to see if I can do is get a running subtractive total column added to the Consumption Schedule but I can't figure out how to a) set the initial value from tblAvailable then b) subtract the values in the Consumption Schedule from it. I've added an index column in my working file.

ex: part001: would start at 18 from tblAvailable, subtract 5 and return 13, subtract 5 and return 8, subtract 5 and return 3, subtract 5 and return -2, subtract 5 and return -7, etc. based on the way it is ordered on the consumption schedule.