how to carry forward previous month data to current month

[harry26]

i made access database using ms access 2007.
it calculates penalty for a given employee for a specific month.i successfully calculate penalty using "Penalty Calc" query.
so at the end wot i have is "employee code"(Empcd),"penalty month nd year"(PYYMM), and total penalty(that is calculated).
now what i want to do is that, suppose i calculate penalty for feb2015, and after recovery of penalty amount there are two options that is due([Recovery]-[Total Penalty]) = 0 or some value. i want to post these details to next month that is march2015.
so it will look like this:

PYYMM Empcd Total Penalty Recovery Due
Feb15 12345 5000 2000 3000
March15 12345 4000+3000 7000 0


(4000=new penalty for march15
3000=Due carried over from feb15)

kindly suggest some idea how to do this?

[June7]

Calculated data should not be saved to table.

What you want can be difficult. Review:

http://allenbrowne.com/subquery-01.html#AnotherRecord

RunningSum property of textbox on report might accomplish what you need.

[harry26]

i am attaching my database here.
all i want to do is put carried forward(CF next) from last month to Carried over(CO Previous) for current month.
help me out.Database.zipDatabase.zip