View Full Version : Calculations in a Report


DanG
12-30-2004, 12:52 PM
I need help!

I am trying to track Vacation, Sick, etc by hours..in the report I am grouping by employee...Employee info is in a group header and the details of the time taken are in the group detail area...I have given codes for Vacation, Sick, etc such as "V" Vacation and in the report I want to sum a all the codes in the group footer for each employee.

I hope I have explained this good enough.

Pat Hartman
12-30-2004, 01:54 PM
Add a control to the group footer and use an aggregate function as its ControlSource.

=Sum(SomeFieldName)