question about % in reports

[Tom Weston]

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

[Keith]

"Tom Weston" <t.********@dl.ac.uk> wrote in message
news:df**********@blackmamba.itd.rl.ac.uk...

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

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