Sum of fields

[ThaBizness]

I have a Access Program and associated reports I have inherited from another developer. The report/app is a time sheet. On this report I have the following sections:

Report Header(Blank)
Page Header (has the reports header)
LastName Header (has the last name of employee)
Detail
DateWorked Footer (Has the actual day and hrs worked that day. One line per day)
LastName Footer (Has totals for employee)
Page Footer
Report Footer (Has Totals over complete report)

Here is my problem. I have 2 fields in the detail section which I am putting a value in a hidden field. The values are:

text33 =IIf([T_JobCode]="9990",[T_RegularHours],0)
text39 =IIf([T_JobCode]="9993",[T_RegularHours],0)

In the DateWorked Footer the following text fields are there for these two values (JobCode 9990 and 9993)

=IIf([text33]=0,Null,"(" & (Format([Text33],"#.00")) & ")")
=IIf([text39]=0,Null,"(" & (Format([Text39],"#.00")) & ")")

When the report is ran this is all fine. I want to get a sum of the hrs for Job codes 9990 and 9993 in the LastName Footer and Report Footer and for the life of me cant figure it out - help

 

[RichO]

Try setting up duplicates of those same 2 hidden fields in the detail section and set their running sum property to Over All. Then in the footer, grab the values from the 2 controls to display them.

 

[ThaBizness]

Rich - That worked great for grand totals for all employees but for the individual user totals are doing a running sum also. If i do the property over group the field is blank.

Any Ideas

 

[The_Doc_Man]

You can have more than one copy of the same hidden field as long as the names are different. THEN, you can have sums of the (different) hidden fields such that the (different) sums have (different) properties - like whether the sum is a grand total or a total only over the group. So heck, have one of each flavor in the detail section, just keep them BOTH hidden.

 

[Rich]

=Sum(IIf([T_JobCode]="9990",[T_RegularHours],0))

 

[ThaBizness]

Rich - U da man!
Thanks everyone who helped me on this