M
Marcus
Hi
I need help. I've been trying to get my brains around this one. I'm trying to use access for data-analysis and while I can work it out in excel, i'm not sure how i can resolve it in access (which is where i need it given the file sizes and i want to run it off a database).
I have the following information
Column A : Delivery Dat
Column B : Orde
Column C : Inventory Item Numbe
Column D : Quantity Issue
My problem is that for any one order and inventry item, there can be multiple deliveries, i want the accumultive total of these based on the delivery date
I want to calcuate : another Column 'E': which equals... Sum of Quantity Issued (Column D) for all incidents where Column B and C are the same and where Column A (Delivery Date) is less than or equal to Column A.
ie., My calculated Column 'E' is a cumulative total of Column D based on the date and matching criteria of Columns B ad C
How do i do this
Thank
I need help. I've been trying to get my brains around this one. I'm trying to use access for data-analysis and while I can work it out in excel, i'm not sure how i can resolve it in access (which is where i need it given the file sizes and i want to run it off a database).
I have the following information
Column A : Delivery Dat
Column B : Orde
Column C : Inventory Item Numbe
Column D : Quantity Issue
My problem is that for any one order and inventry item, there can be multiple deliveries, i want the accumultive total of these based on the delivery date
I want to calcuate : another Column 'E': which equals... Sum of Quantity Issued (Column D) for all incidents where Column B and C are the same and where Column A (Delivery Date) is less than or equal to Column A.
ie., My calculated Column 'E' is a cumulative total of Column D based on the date and matching criteria of Columns B ad C
How do i do this
Thank