hockeylvr
Technical User
- Nov 26, 2002
- 140
Could someone please tell me what type of query/function I should be looking for to accomplish this task:
I have a table of projects. Each project has a cost savings effective date, i.e. 5/1/06. The total savings for each project is based on monthly volumes in another table. I have to calculate the savings for each month from the effective date + the next 11 months. Each month will be different.
Project 1 - reduction of $.50 effdate of 5/1/06
Need to calculate
May volume - 100 Savings for May - $50
June volume - 200 Savings for June - $100
July volume - 150 Savings for July - $75
Through April 2007
Do I need to create a query with fields for each month(which I can already do) or is there something I can do in VBA like a for/loop function that will go through and calculate each month? I really don't even care if it calculates past 12 months, I just need to get the monthly's calculated.
Would appreciate any help.
I have a table of projects. Each project has a cost savings effective date, i.e. 5/1/06. The total savings for each project is based on monthly volumes in another table. I have to calculate the savings for each month from the effective date + the next 11 months. Each month will be different.
Project 1 - reduction of $.50 effdate of 5/1/06
Need to calculate
May volume - 100 Savings for May - $50
June volume - 200 Savings for June - $100
July volume - 150 Savings for July - $75
Through April 2007
Do I need to create a query with fields for each month(which I can already do) or is there something I can do in VBA like a for/loop function that will go through and calculate each month? I really don't even care if it calculates past 12 months, I just need to get the monthly's calculated.
Would appreciate any help.