D
danapp
I have a query that has wages, payroll taxes, pension, all based on hours
worked per day. Meaning if Joe worked 8 hours on 3-1-07 then it would
calculate each of these amounts time the hours worked and give me a total for
each of these items. I keep track of 90 employees this way and each employee
has a minimum of 15 entries a month. My problem is I also have a table that
just has one lump sum each month for health insurance. I was wondering the
there is a formula I could write that would look at each employee how many
days they worked for the period I'm looking for and divide it by the days
worked to give me a per day rate. Right now when I run the query it gives me
the lump sum amount each day the employee works which is obviously to high.
Thanks
worked per day. Meaning if Joe worked 8 hours on 3-1-07 then it would
calculate each of these amounts time the hours worked and give me a total for
each of these items. I keep track of 90 employees this way and each employee
has a minimum of 15 entries a month. My problem is I also have a table that
just has one lump sum each month for health insurance. I was wondering the
there is a formula I could write that would look at each employee how many
days they worked for the period I'm looking for and divide it by the days
worked to give me a per day rate. Right now when I run the query it gives me
the lump sum amount each day the employee works which is obviously to high.
Thanks