Help with sum in Group Footer

[dianneleigh]

Good morning,

I am working on a database for employee timecards. I have the following tables

EMPLOYEES
Name
Address, etc

TIIMECARDS
TimeCard ID
Employee ID

TIMECODES
TimeCodeID
TimeCode
TimeCodeDescription (sick,vacation,etc)


TIME CARD DETAIL
TImecard Detail ID
Timecard ID
Date
TimeIn
TimeOut
Lunch
TimeCodeID

I am creating a report to for weekly time based on begin and end dates. This report is grouped by employee with The employee name in the header. I need to total time for each employee in the group footer for each employee.
Right now I have a field that calculates the time based on time in, out and lunch. I have another field puts the total for each time code selected. For example....if the time code is sick time it pulls the total into that text box.

I need to total that field on the bottom of each group as well as at the end of the report. I hope all that makes sense.

 

[Gasman]

I have done exactly the same thing and all I have is

=Sum([Hours])

where Hours is the value between the two times for each employee.

For the report footer I expect you would want a running total.?

HTH

 

[Minty]

duplicate the control in the footer, and select running sum over group in the properties.

 

[dianneleigh]

duplicate the control in the footer, and select running sum over group in the properties.

This isn't working.

 

[Minty]

Ah - no it won't. You should do that calculation in your reports underlying query, then a simple sum on the report will work.

 

[dianneleigh]

Ok - I'll try that. Thanks so much!