"Tom Weston" <t.m.weston@dl.ac.uk> wrote in message
news:dfrk3o$deu$1@blackmamba.itd.rl.ac.uk...[color=blue]
>I am stuck with this problem, I wish to create a report of hours booked to
> different project numbers each month covering several years. Assume I have
> 6
> project numbers each year each with a different total of hours booked to
> them. I want to sum the hours booked for the year and to give a total for
> the year and show against each project number the percentage booked that
> year. I also want to show a grand total of hours booked at the end of 3
> years. The example below may be clearer.
>
> for example
> 2004
> proj 1 1 hr 10%
> proj 2 2 hr 20%
> proj 3 7 hr 70%
>
> total for year 10 hr
>
> 2005
> proj 4 2 hr 20%
> proj 5 3 hr 30%
> proj 6 4 hr 40%
> proj 7 1 hr 10%
>
> total for year 10 hr
>
> grand total 20 hr
>
> Thanks in advance Tom
>[/color]
Create group footers for each year and a report footer and use the "Sum"
function in a text box to display the totals.
HTH - Keith.
www.keithwilby.com 
