Accumulation Over Time

[element32d]

Hello,

I have a relatively simple idea that I'm not sure how to do in Access. I uploaded a sample database for reference.

I have a query gathering information from the "Order Entry" table. So right now there's an entry for 5000 of "01234" due 6/15/2013 and another 5000 of "01234" due 6/20/2013. In the query it is showing both of them, but what I want it to do is accumulate every order entry. So for 6/20/2013 it should show "10,000" in the order quantity field.



If this can't happen easily, the least it could do or maybe even a better solution would be to let 6/20/2013's order show up because there's a short order for 6/15/2013. This doesn't happen for some orders because if say, there's an order for 80,000 due 6/15 and current inventory is 75,000, and another order for 30,000 is due 6/20/2013, that won't show up even though technically it should because it's still short since that first order will deplete the inventory to less than 30,000.

Thanks!

[rpeare]

You're talking about a running sum.

Here's how you do it on a query:
http://support.microsoft.com/kb/290136

Here's a method to do it on a report (if you're using a formula instead of just a number):
http://www.blueclaw-db.com/access_re...unning_sum.htm

Here's a method to do it on a form:
http://support.microsoft.com/kb/210338

[element32d]

You're talking about a running sum.

Here's how you do it on a query:
http://support.microsoft.com/kb/290136

Here's a method to do it on a report (if you're using a formula instead of just a number):
http://www.blueclaw-db.com/access_re...unning_sum.htm

Here's a method to do it on a form:
http://support.microsoft.com/kb/210338

So I can do this in my situation, where there will be different part #'s in the same query and it's running a total for each part # individually?

EDIT: I attached my attempt. Any insight on why it's not working?