Hello,
I am trying to figure out the best way to start a db to track points.
Basically my data consists of
Clock number
Employee name
in one table
and
Observer points is worth 2 points
Observee points is work 1 point
Tool box talks are worth 3 points
LOTO is worth 2 points
I am not sure where to begin.
I would like to have an end result that looks something like this:
0111 John Doe 4 observer points 1 observee points 6 tool box talks 0 LOTO
I have a table imported from excel for the clock number and employee name. I don't know much about joining (inner or outer) tables but I am trying to learn.
Can anyone point me in the right direction.
I am trying to figure out the best way to start a db to track points.
Basically my data consists of
Clock number
Employee name
in one table
and
Observer points is worth 2 points
Observee points is work 1 point
Tool box talks are worth 3 points
LOTO is worth 2 points
I am not sure where to begin.
I would like to have an end result that looks something like this:
0111 John Doe 4 observer points 1 observee points 6 tool box talks 0 LOTO
I have a table imported from excel for the clock number and employee name. I don't know much about joining (inner or outer) tables but I am trying to learn.
Can anyone point me in the right direction.
