Chief Delphi - Microsoft Access Help

Ok everyone, I need your help. I’m trying to create a simple database template for robotics teams in MS Access hopefully to be used in 263s upcoming season, if we have one. I’m using MS Access 2003 and I’m trying to create a Transaction Log table like this.

Code:

Description   Amount   Date    Balance

--------------------------------------

Sponsorship   $11,000 9/21/05  $11,000

Registration ($6,000) 9/22/05   $5,000

The thing is, I want the Balance field to automatically fill in by adding the value of Amount to the previous fields Balance value, or if it’s the first entry in the table then setting the balance equal to the amount. Is there any way to do this?

Thanks all.