Loop in Query ? that will update field based on previous field value

[mindoff]

I'm very beginner in Access and challenges I'm facing is over my skills

Due to large amounts of data to be calculated I need to move my excel data to access.
I have created 3 tables: stock, orders and demand.



based on them I need to update Balance in table Schedule for each item in each week of year



first I need to sum quantites from 3 tables for youngest week in youngest year (51/2016),
then base on this i need to update following weeks for all my 2000 items.



many thanks in advance for suport

Konrad

[rpeare]

Don't do this in a query, running sums (or calculations based on running sums) are much more efficiently handled in reports. You would not be able to use this proposed query for data entry anyway so the report would be your best alternative.