Jump to content

Job Summary


Troy Hyde
 Share

This topic is 5645 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 5645 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.