Productivity Database- all employees must account for 8 hours

[eskara]

I need to build a database that tracks the productivity of workers. They will be entering their name, task, time to complete the task, number of files used while working on the task, date, and comments. My manager wants me to work in some way to check that each employee has accounted for at least 8 hours every day and to give that employee an error message if they have not. I'm not sure if I should do this as a macro (or if that would even work!) or how I could make Access tally the time totals.

Thank you so much for any help!

[eskara]

Oops! I forgot to specify; I am running Access XP on Windows XP.

[MMcCarthy]

I need to build a database that tracks the productivity of workers. They will be entering their name, task, time to complete the task, number of files used while working on the task, date, and comments. My manager wants me to work in some way to check that each employee has accounted for at least 8 hours every day and to give that employee an error message if they have not. I'm not sure if I should do this as a macro (or if that would even work!) or how I could make Access tally the time totals.

Thank you so much for any help!

You would need to create a query grouped by EmployeeID and Date and sum the time to complete the task field. If you post the table metadata we can help you to build the query.

Mary

Here is an example of how to post table MetaData :
Table Name=tblBookings

Field; Type; IndexInfo
 Field; Type; IndexInfo
StudentID; Autonumber; PK
Family; String; FK
Name; String
University; String; FK
Mark; Numeric
LastAttendance; Date/Time

[eskara]

Hmmm.... I'm going to sound like a total idiot here... How do I find the metadata to post it?

[MMcCarthy]

Hmmm.... I'm going to sound like a total idiot here... How do I find the metadata to post it?

Open the table in Design view.