.So here is an idea.

Using Excel, Load up a table with all the consecutive days between now and say 10 years from now. Set the key feild to be the date field.

Make a formula field on the table which calculates the previous day from that key date field.

[Date] - Days(1)

Make a relationship of the table to itself and on the right side of the relationship for the reference field use that formula field. QuickBase will let you make a relationship of a table to itself it will just doublecheck with you to make sure that�s what you really mean.

So now you can make another relationship of the state table down to your detailed records. Of course on the right-hand side of the relationship you will need to have a formula field if you don�t already have a clean date field on the detail table. It looked from your example that you had a date time field.

So now the data table can have that relationship do a summary of the Production numbers for that day. And then based on the relationship of the data table to itself can look up the previous days total production into the current days total production to have a running total. So now that running total can be locked up back down into your production dates table.

Of course somehow you will have to decide when the running total starts at zero.