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?