I am not very experianced in utilizing loops and recordsets but can not think of any other way to accomplish what i need.
I have a table shown here. I want to forcast out when the projects below will be complete by year complete. So basicly I need to take the average units/day and figure out what the total per year is and create a record for each project and year till the project is closed.
Expand|Select|Wrap|Line Numbers
- table1
- Project Units/day Total_Units
- Project 1 4.29 259
- Project 2 1.94 152
- Project 3 3.19 82
- Project 4 2.30 72
- Project 5 0.16 70
- Table2
- Project Year Units_Forcasted
- Project 1 2012 100
- Project 1 2013 100
- Project 1 2014 59
- Project 2 2012 125
- Project 2 2013 27