Job Summary

[Troy Hyde]

I have set up a time card database.

Each Time Card can have up to 25 job names and 7 days worth of time for each job.

I am looking to be able to have a summary that will print out per job. (ie.

Week Ending 5/5

Job #1

Jim 13hour

Paul 16 Hours

Job #2

Sam 14 hours

Jim 6 hours

)

The summary need to be for the time cards in a given week ending date, and should give to total hours worked in that week by each employee on each job.

Any Ideas?

[Fitch]

This is a many to many relationship:

many employees >-< many jobs.

You need to make a table for employees, another table for jobs, and a third table (e.g. "hours") that joins employees and jobs:

employees -> hours <- jobs

The join table needs the emp. ID, job ID, and hours fields, as well as a summary field for total hours. Run your report from this table, it would be a simple subsummary sorted by job/employee.