Access: Report Example (Employee hours worked per day) in Access 2003/XP/2000/97
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.
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.
