I want to creat a database that acts like a checkbook register. I am hving trouble keeping a "current balance". Lets say I have a field called "amount". How do I subtract this number from another total (current balance) and then keep this a running total?

I am a newbie to all of this.

Thanks!