Carryover or running total inventory help

Hey Mark, thank you, I will try this tonight. I've been wanting to experiment with relating a table with itself. I didn't mention, if it matters, that we only have 1 record for each 15 day period, not daily records; and really only modify the record at the end of the 15 day period, not daily. Additionally, the Invoice Period Table and the associated related field don't use a date, it's just a text string. I.E. '1-1 to 1-15'. But maybe setting the key field will still work. There is a possibility of one of our locations missing a period and breaking the chain by virtue of closing and then opening again a month later. But I suppose I could make non-change records to bridge the gaps. The other complication, of course it's not cut and dried haha, is that each of our 40 locations, each of which has a distinct inventory, have different lengths of service each year and open and close at different times. For instance one location is open from 4-15 to 7-31 and another is open from 6-1 to 10-31.

------------------------------
Brian Hunot
------------------------------