Hello,
I have an access table downloaded from an ERP system that has production data as follows:
Production Order
Date Produced
Part Number
Cumulative Qty Produced
My issue is that each day the ERP overwrites the days previous qty if the production order has additional production. I need to be able to come up with the production for the DAY, not the cumulative order production quantity.
What kind of query can I write that will back out the previous quantity produced on an order.
Raw Data:
Order Date Part Cum Qty
123 1/1/13 ABC 2
123 1/2/13 ABC 4
123 1/4/13 ABC 8
I need:
Order Date Part Daily Qty
123 1/1/13 ABC 2
123 1/2/13 ABC 2 (4 - 2)
123 1/4/13 ABC 4 (8 - 4)
Thanks for your help!
I have an access table downloaded from an ERP system that has production data as follows:
Production Order
Date Produced
Part Number
Cumulative Qty Produced
My issue is that each day the ERP overwrites the days previous qty if the production order has additional production. I need to be able to come up with the production for the DAY, not the cumulative order production quantity.
What kind of query can I write that will back out the previous quantity produced on an order.
Raw Data:
Order Date Part Cum Qty
123 1/1/13 ABC 2
123 1/2/13 ABC 4
123 1/4/13 ABC 8
I need:
Order Date Part Daily Qty
123 1/1/13 ABC 2
123 1/2/13 ABC 2 (4 - 2)
123 1/4/13 ABC 4 (8 - 4)
Thanks for your help!
