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.