A report is built using start and finish dates. It results in a individual name and a number of weeks. Each week is totalled in the report footer. I also want to total the amount from each week for each individual. The query the basis of the report has 52 weeks which in turn comes from a table with 52 weeks in each record. therefore I cannot add a control to the table or query to sum the weeks as until the report is built I do not know what weeks will be in it. As I enter the weeks inthe report I tried to add a result which would have been the summation of the weeks but that does not work in design view (understanably). I assume the solution is to build a query programatically but have not been abale to figure out how.
Any help greatly appreciated.
thanks
Peter