Thread: Moving Average
10-22-04, 01:23 #1Registered User
- Join Date
- Oct 2004
Unanswered: Moving Average
Can anybody tell me how can I calculate running average for my databse used to calculate inventory transaction in Ms Access XP?
The basic logic is I want a query to calculate running average for (sum(Unit Cost * (Quantity Purchased-Quantity Issued))/Sum(Quantity Purchased-Quantity Issued))
I have got this code and it turned to be returning error in calculating for the first row for the rest it calculates cool even though it only calculates based on one field (Unit Cost)
Thanx a lot
Last edited by Jonas A; 10-23-04 at 01:11.