I am sure my project is too big for my level. Here is my problem.
I am attaching a trial database. Each record has manhrs, and a start date & Finish date. The Manhrs are distributed linearly to simplify. The idea is to ditribute all the manhrs summed in a summary, distributing throughout the year on a weekly basis. So that I can draw a Curve for the Manhrs requirement.
I am not sure which way to go. Thought of creating Global fields for each week of the year and going through a loop to check each record and adding the weekly data from a record, depending on whether the week falls between the start date & Finish date, add weekly manhrs. Thats very complicated...can you Gurus think of an easier method PLEASE?
Thanx a million in advance
trial.zip