Total values for specific records

[Guest]

I have a form which includes two subforms. The main form includes basic
employee details. The first subform lists (in tabular form) the jobs that the
selected employee does (basic information like job number, client name). The
second subform shows detailed information of hours worked and monies paid for
a particular job selected in the first subform. I have totalled the number of
hours worked on a particular job but I would also like to total hours wrked
on all jobs for a particular employee.

How do I go about this?

Thanks

David

 

[Guest]

Hi, David.

Use a Totals query, grouping by EmpID and JobID, and summing Hours.
Something like:

SELECT Hours.EmpID, Hours.JobID, Sum(Hours.Hours) AS SumOfHours
FROM Hours
GROUP BY Hours.EmpID, Hours.JobID;

Sprinks