Conditional summation in Report

[Rattlesnake]

hi,
I have a table that records the Time attendance of employees and has the following fields
TIMEIN- TIMEOUT- OVertime -OvertimeType

The records have the values like the follwing:

09/03/2003 8:00 - 09/03.2003 22:00 - 4.00-150

The overtimeType determines whether the Overtime has to be paid at 150% or 200%.

I want to create a report , that will display all the records in the table grouped by the employees and showing the total overtime at 150% and at 200% in the group footer of each employee ,Like this
150 % Overtime =<SUM of OVertime at 150%>
200 % Overtime =<SUM of OVertime at 200%>

I have created the report , and can display the records, but cant get the SUM in the group footer.
What formula should i use . I know it will be something like (Sum([Overtime])). But how do i sum the 150% and 200% seperately.

Thanks

 

[Brianwarnock]

Had hoped sombody else would pick this up as I'm off for a few days but I think that you will need to do this at query level and include the result in the report.

Brian

 

[Rich]

Create two more groups on the report 150% and 200% resp. =Sum([YourField]) in both the footers will do what you want. =Sum([YourField]) in the Employee footer will sum the total overtime per employee