How to maintain a running total

[aliyallah]

My friends, please help me figure this out. I am new to MS-ACCESS. I am trying to create a simple Leave system for my office. When a user requests a leave, the number of hours will be added to a table. I have created a form for this purpose. What I would then like to happen is, the next field in the Table is the sum of hours requested thus far. So that field would be Requested + Total requested Thus far. I can do it easily in Excel but I can't figure out how to do that in ACCESS. It is a very simple database and I can mail you my sample if you are interested. Thanks in advance.

yallah.

aliyallah@yahoo.com

 

[aliyallah]

Perhaps it will be best if I post a pic of the sample database I have. Here it is

 

[aliyallah]

Here is a zip of the database itself. Please help. I need to have this in on Monday (tomorrow)