Hello

I am developing a small application on employee leave status.i have taken a leave table in that opening balance,consumed leaves,credit leaves and balance leave are my columns.if employee taken leave means im doing

balance leave=opening balance+credit balance-consumed leave.

but when i move to next month automatically my balance leave of the current month must be my opening balance.

so how to update.please give me some suggestions using asp.net,C#.

Regards,
Vamshi