Access Quesry

[Guest]

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

 

[Jeff Boyce]

It sounds like you are trying to do basic calculations on your data ... and
spreadsheet do that much better than relational databases.

Is there a reason you aren't doing this in Excel?

Regards

Jeff Boyce
Microsoft Office/Access MVP