Previous Payperiod Ending Sick Time

Hello - I have a database that is almost finished but unsure on the final calculations and how to get the correct data to flow to the next payperiod.

Each payperiod someone enters all staff members hourly time, vacation time used, sick time used, etc... Depending on the staff members status (fulltime or parttime), they accumulate a certain amount of sick and vacation hours but can never exceed the maximum in any given payperiod.

I have a query (which is dependent upon another query) that calculates the beginning sick time, sick time used, sick time earned, and gives me the remaining sick time and it works fine for the first payperiod.

However, I do not understand how I can get the remaining sick time to become the beginning sick time for the next payperiod. Is this done in the same query? A different query? A different method?

I have been beating my head against the wall for several days. Any guidance would be greatly appreciated!