I am trying to calculate total down time and total production running time per employee. My table's field names are as follows:
(ID) (User_Name) (Event) (Time_Stamp) (Down/Running)
1 Mark Start Production 7:00:00 AM Running
2 Jill Start Production 7:00:00 AM Running
3 Rich Start Production 7:00:00 AM Running
4 Mark Machine Failure 8:00:00 AM Down
5 Rich Out of Parts 8:10:00 AM Down
6 Mark Start Production 8:20:00 AM Running
7 Jill Changeover 8:45:00 AM Down
8 Mark Start Production 9:00:00 AM Running
9 Rich Start Production 9:10:00 AM Running
10 Jill Start Production 9:15:00 AM Running
11 Mark Clock Out 12:00:00 PM Down
12 Jill Clock Out 12:00:00 PM Down
13 Rich Clock Out 12:00:00 PM Down
Questions:
(1) How do I create a selective query which calculates Mark's Total run time and Down Time?
(2) How do I do the same for the others individually?
(3) How do I create a form showing the accrued or total down time and run time as it happens?
Please help, I need some ideas....
Thank you.....