I have created a form so that sections A - D can enter progress such that a weekly tally can be made to create a glide path of work remaining to the end of the project and also
progress to current forecast (relating the completed work to the expected work)

Some sections may not actually have any planned or completed work for any paricular week. I have used a select distinct and group by query to get any week where some progress was
entered and by whom, and used the Group function in the query to derive weekly progress by Section.

Looking for advice as to what is the best way to develop this into a chart showing progress by week for individual sections, and then cumulative along the time line adding up the
totals as they go from week to week. I like to try and make procedures fairly generic, so they can be re-used with just changes to labels and underlying queries required if possible.
I thought that a nested loop approach might work such as creating a recordset from this query and then adding the totals together for each instance of WeekNumber saving them into a
new table as the data for the series of the chart?

Thanks

J




WeekNumber Section ProgressNumber
1031 A 4
1031 B 2
1031 C 2
1031 D 1
1032 A 1
1032 B 2
1032 C 5
1032 D 1
1033 B 2
1033 C 1
1035 A 2.45
1035 B 0.8
1035 C 1.9
1035 D 1.9
1036 A 45.5
1036 B 3.65
1036 C 33.9
1036 D 64.25
1037 A 2.05
1037 C 2.3
1037 D 12.8
1038 A 3.95
1038 B 8.25
1038 C 55.7
1038 D 60.19



--
--------------------------------- --- -- -
Posted with NewsLeecher v3.9 Final
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -