8/04/2012

Report Example (Employee hours worked per day)

Question: In Access 2003/XP/2000/97, I have a database where I report employee hours daily. I need a report that displays the hours worked daily and the total of hours worked per week per employee.
Answer: We've created a sample Access database that contains the tables, queries, and reports required to demonstrate this example.

Download Access 2000 version
This database contains a Personnel table with the following fields:
Field Name Datatype
Employee Name Text
Date Date/Time
Time In Date/Time
Time Out Date/Time
We've created a query called "Hours per day" which takes two parameters as input - the starting day for the report and the ending day.
This query is used by the report called "rptHours per day" which displays the hours worked per day as well as total hours for each employee.

No comments:

Post a Comment