By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,661 Members | 779 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,661 IT Pros & Developers. It's quick & easy.

Productivity Database- all employees must account for 8 hours

P: 10
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!
Mar 14 '07 #1
Share this Question
Share on Google+
4 Replies


P: 10
Oops! I forgot to specify; I am running Access XP on Windows XP.
Mar 14 '07 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Expand|Select|Wrap|Line Numbers
  1. Field; Type; IndexInfo
  2. Field; Type; IndexInfo
  3. StudentID; Autonumber; PK
  4. Family; String; FK
  5. Name; String
  6. University; String; FK
  7. Mark; Numeric
  8. LastAttendance; Date/Time
Mar 17 '07 #3

P: 10
Hmmm.... I'm going to sound like a total idiot here... How do I find the metadata to post it?
Mar 21 '07 #4

MMcCarthy
Expert Mod 10K+
P: 14,534
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.
Mar 21 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.