L
Ljffusion1
Hi all
I took a lot of advice, my thanks to all!!
Now I need to create production Reports.
I have 2 Tables one for Production which stores the operation ID, The
description, the Date, Employee Name, start time, End Time, Total
Time, and quantity.
The second Table is for production goals.
It will store the totals, the fields are, Operation id, the catagory,
employee name, perhour, perweek, permonth. not sure if I need more.
Basicly this is how the data is placed.
the operationid is 10,20,30,40 etc.
the catagory is the description of the code, ie. 10 = Boxes Cleaned,
20 = Boxes Repaired and so forth
My boss wants to be able to put in a date range by week or by month.
for each employee. then enter the code for the job they did and have
the total quantity they did with the total time it took.
The standard rate is 60 boxes per hour. so the total would be divided
by 60
Thanks
I took a lot of advice, my thanks to all!!
Now I need to create production Reports.
I have 2 Tables one for Production which stores the operation ID, The
description, the Date, Employee Name, start time, End Time, Total
Time, and quantity.
The second Table is for production goals.
It will store the totals, the fields are, Operation id, the catagory,
employee name, perhour, perweek, permonth. not sure if I need more.
Basicly this is how the data is placed.
the operationid is 10,20,30,40 etc.
the catagory is the description of the code, ie. 10 = Boxes Cleaned,
20 = Boxes Repaired and so forth
My boss wants to be able to put in a date range by week or by month.
for each employee. then enter the code for the job they did and have
the total quantity they did with the total time it took.
The standard rate is 60 boxes per hour. so the total would be divided
by 60
Thanks