Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Grouped Report Total

Status
Not open for further replies.

RedTagg

IS-IT--Management
Dec 10, 2002
1
GB
Hello, I have a grouped report setup so that it looks like this:
---------------------------------
Header
-------------Titles--------------
Person Name | Hours | Cost
--------------Data---------------
Person Name | Hours | Cost
---------------------------------
Footer
---------------------------------
I want to know how I can add a text box and what I have to put in it to give me the totals for all of the costs for that one person. All I get is a list of ther hour and costs
like this;

Name
Hours Cost
1 £3.00
2 £6.00
Name
Hours Cost
1 £3.00
2 £6.00

But I need to add the totals if you see what I mean. All I seem to get with totals is this:

Name
Hours Cost
1 £3.00
Total £3.00
2 £6.00
Total £6.00
Name
Hours Cost
1 £3.00
Total £3.00

etc

Can anyone please help, because I have no idea how to add up the totals of all of the cost fields as some have one and others have lots, or even where to put the total text box

Thanks
 
You should add a grouping level for the "persons" primary key (employee id). Create a field that has this formula in the control source property =sum([cost]) and place this in the footer of that persons primary key footer.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top