Results 1 to 1 of 1

Thread: Moving Average

  1. #1
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts