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