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.