Search results for query: *

I have a table with payroll transactions and a table with dept activity (dates employees were transferred to another dept). I am trying to make a query that will add the correct dept for each payroll transaction DeptAct Emp Dept TDate 101 201 01/01/05 101 202 02/01/05 Payroll Emp Amt PDate 101...

I have a table with payroll transactions and a table with dept activity (dates employees were transferred to another dept). My query is supposed to list the payroll transactions along with the dept the employee was in at the time. DeptAct Emp Dept TDate 101 201 01/01/05 101 202 02/01/05...

I am trying to create a query that will give me the total cost per employee/Month/Dept. Table #1 – Employee #, Month, Payroll Amount, Dept # Table #2 – Employee #, Month, Benefit Amount Table #3 – Employee #, Month, Deduction Amount When an employee switches departments he will have more then...

I have a query that has the following 3 fields Dept, Sequence #, Amount I am trying to add a field (in this query or a new one) that will average the amount per record with the amount of the record with the previous sequence #. Thanks for any help.