J
Jan Il
Hi all - Access 2000 - WinME
I am in need of a query to calculate employee labor costs based upon the
employee job classification or employee ID. I have a table that lists the
employee ID number and their job classification. This is related to a table
that lists the hourly rate based upon the job classification. I have a data
entry form to enter repair activities, but, we need to be able to track the
man-hours to complete the repairs, and the cost of labor based upon either
the employees job classification, or employee ID, which is related to their
job classification hourly wage amount.
I am not sure which of these would be the best to use to get the
calculations I need. What I am thinking is using the employee ID number,
which is tied to the job classification hourly wage amount. But, since
their job classification can change, with their training and elevation from
Apprentice to Master Electrician...perhaps the job classification should be
used instead of the employee ID number. However....their employee number
will never change, but, their job classification can....?<>?
I am just not sure which way I should set up the query to select and
calculate this information. I will need a control on the entry form to make
the selection for the manner of how the cost is calculated, which I am
thinking a drop down or list box with all the employee ID's or the job
classifications....whichever way I need to go.
I would truly appreciate some input or suggestions on this, or perhaps a KB
or Help file that might clarify this issue. Hope I have explained it
somewhat clearly, but, if not, I'll run a search of the the gray-matter
between the ears for a hopefully better explanation. ;-))
Best regards,
Jan
I am in need of a query to calculate employee labor costs based upon the
employee job classification or employee ID. I have a table that lists the
employee ID number and their job classification. This is related to a table
that lists the hourly rate based upon the job classification. I have a data
entry form to enter repair activities, but, we need to be able to track the
man-hours to complete the repairs, and the cost of labor based upon either
the employees job classification, or employee ID, which is related to their
job classification hourly wage amount.
I am not sure which of these would be the best to use to get the
calculations I need. What I am thinking is using the employee ID number,
which is tied to the job classification hourly wage amount. But, since
their job classification can change, with their training and elevation from
Apprentice to Master Electrician...perhaps the job classification should be
used instead of the employee ID number. However....their employee number
will never change, but, their job classification can....?<>?
I am just not sure which way I should set up the query to select and
calculate this information. I will need a control on the entry form to make
the selection for the manner of how the cost is calculated, which I am
thinking a drop down or list box with all the employee ID's or the job
classifications....whichever way I need to go.
I would truly appreciate some input or suggestions on this, or perhaps a KB
or Help file that might clarify this issue. Hope I have explained it
somewhat clearly, but, if not, I'll run a search of the the gray-matter
between the ears for a hopefully better explanation. ;-))
Best regards,
Jan