T
Tara
I posted about part of this yesterday and got some great advice, but I just
found out there are other issues that no one told me about. Here's the
problem:
I'm trying to create a query that will calculate how much someone has
contributed year-to-date to their supplemental health care plan. Basically
the employee agrees to contribute an amount of their choosing. This amount
is then divided out so that the individual pays a certain portion of that out
of each bi-weekly paycheck. We also need to stop calculating a running
total for those employees who terminate, and instead calculate their
contributions only up to their termination date. I got this part figured out
yesterday.
Now, here's the part no one told me about: I also need to have a table
where each payroll deduction is listed, by date. This is so that if someone
takes FMLA or is not working for a period of time, we can delete that
deduction (since they wouldn't be getting a paycheck). So, I need a query
that can calculate the dates of each paycheck and have that appended to a
table every 2 weeks along with amount deducted from that paycheck.
Any ideas on how to start?
found out there are other issues that no one told me about. Here's the
problem:
I'm trying to create a query that will calculate how much someone has
contributed year-to-date to their supplemental health care plan. Basically
the employee agrees to contribute an amount of their choosing. This amount
is then divided out so that the individual pays a certain portion of that out
of each bi-weekly paycheck. We also need to stop calculating a running
total for those employees who terminate, and instead calculate their
contributions only up to their termination date. I got this part figured out
yesterday.
Now, here's the part no one told me about: I also need to have a table
where each payroll deduction is listed, by date. This is so that if someone
takes FMLA or is not working for a period of time, we can delete that
deduction (since they wouldn't be getting a paycheck). So, I need a query
that can calculate the dates of each paycheck and have that appended to a
table every 2 weeks along with amount deducted from that paycheck.
Any ideas on how to start?