Sum of each grouped item in a report

[SteveP]

I have a form that logs time spent on auditing activities for the Internal
Auditors in my company. Each time the auditor performs an audit related
task, they enter a new record under their name. This means they could have
many occurences of the same function. I then created a query/report that
breaks down the different auditing activities for each internal auditor.
Management has now asked for a report that gives a total for each activity
for each internal auditor (example - John Smith: Audit Prep - 2.25, Follow-up
- 3.75, Audit - 7.50). I want to figure out how to do this on a report for
each individual auditor before I try to tackle a year-end report that shows
all activities for all auditors and the totals for each activity and each
auditor overall.

(how I would like it to look)
John Smith
Audit Prep
2/5/08 2.25
2/9/08 1.50
Total: 3.75
Audit
2/5/08 4.75
2/6/08 3.50
2/9/08 5.00
Total: 13.25



Thanks for any and all help.

 

[Stockwell43]

Hi Steve,

If I understand what you're asking for, open the group footer of the Auditor
field in your Group/Sort and copy the field that is giving you your numbers
into the footer. Then, open that text box's properties and in the Control
source try =Sum([name of your texbox you copied]) and it should total like
your showing in your post.

 

[SteveP]

Used a combination of both of your answers. Thank you for your help. Now if
management with just be happy with the resulting report everything would be
good.

I have a form that logs time spent on auditing activities for the Internal
Auditors in my company. Each time the auditor performs an audit related
task, they enter a new record under their name. This means they could have
many occurences of the same function. I then created a query/report that
breaks down the different auditing activities for each internal auditor.
Management has now asked for a report that gives a total for each activity
for each internal auditor (example - John Smith: Audit Prep - 2.25, Follow-up
- 3.75, Audit - 7.50). I want to figure out how to do this on a report for
each individual auditor before I try to tackle a year-end report that shows
all activities for all auditors and the totals for each activity and each
auditor overall.

(how I would like it to look)
John Smith
Audit Prep
2/5/08 2.25
2/9/08 1.50
Total: 3.75
Audit
2/5/08 4.75
2/6/08 3.50
2/9/08 5.00
Total: 13.25

Those totals can be calculated in an activity group footer
text box by using an expression like:
=Sum([loged time field])