MS Access 2003: Report Example (Employee hours worked per day)
This MSAccess tutorial explains a report example that displays hours worked daily and the total hours worked per week per employee in Access 2003 (with screenshots).
Question: In Microsoft 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.
Advertisements