Access 2010 Rolling Deduction or Negative Sum?
Posted on 2014-12-16
Working with a form and subform, there are examples of calculating the sum of the records on the subform and displaying the total on the form. Is it possible to have a rolling deduction? For example; 75 units were completed on an order of 100, 50 last week, 25 so far this week, with 25 left for next week.
Form: 75 units completed
Date Completed, Build Qty, Qty completed, Qty remaining
subform: last week, 50, 50, 50
this week, 25, 25, 25
next week, 25, 0, 25
As the form units completed increases, can the subform qty completed and qty remaining fields update also?