Overtime Tracking

[cpl_usmc]

I am at my wits end. I am looking to create a database to keep track of overtime taken and have it sort so the person with the latest date is at the top of the list.



I need to be able to add many entries to each employee and have the ability to sort by work group (eg group 1, group 2, group 3, etc...)

So in summary I need to have the ability to enter an employee work group and find out who in that group is next up for overtime (rotating basis). When I figure out who gets the overtime I need to be able to add it with a date and then have them sorted so they come up last next time.

I will take any and all suggestions. I am attaching my latest try. Go to the form "overtime list" and you can see what I was trying. Thank you for any and all help

[wdrspens]

I could find nothing attached to your post.

I have the following suggestion to make.

Use at least two tables

EmployeeT Table.
Fields:
EmployeeID - autonumber and primary key
WorkGroup - text
Any other fields.

WorkT Table
Fields:
WorkID - autonumber and primary key
EmployID - number (related on a one to many relationship with EmployeeID)
EmployeeName - text
DateWorked - date/time
Any other fields.

Have a query, WhenWorkedQ, based on the Work table and use DMax to find the most recent date each employee worked, sort the field showing the DMax in, I think, descending order so that the person who has most recently worked is at the bottom. Experiment with the order to get it right.

Have another query, GroupWhenWorkedQ, based on the EmpoyeeT table and the WhenWorkedQ query. Group that query according to WorkGroup

Display the results in a table specifying the WorkGroup and with a subtable for the employees in each WorkGroup.

I have no idea whether that will work, but it is a suggestion to get you going.

Good luck