Help with Totals in SubForm pls.

[aliyallah]

folks,
I have two simple tables in a database. One Table is the entry table and the other is the totals. I then created a Form and a subform from the two tables. What I would like is to maintain running totals in the subform as entries are made in the entry table. Attached is the Database. Please help.

 

[aliyallah]

Sorry, the attachment did not come through. Here it is in zip format.

 

[Oldsoftboss]

You need to look at your table setup. You need a table for personel and the total Leave etc, then a subform that subtracts from the main table. The balance does not get stored, it is simply calculated. I suggest you also include a "last Updated" field that allows you to know when you last updated the leave available.

Dave