Running balance

[bka57]

In the "forms" section, using the "design" view, I have created a form which I use to input my checkbook information. Included in this form are the following fields/columns:
Transaction Date
Transaction Description
WithdrawalAmount
DepositAmount
AccountID


Balance

The balance column is a formula I defined as =sum([depositamount]-[withdrawalamount])

My problem, regardless of how many entries I make, the balance column always has the same number in it. Although the balance for the last entry is correct, that same balance shows for every entry I make.

I am running Access 2007 on Windows XP. I have tried to find the answer to this problem myself but have had no luck. Many solutions show that I should have a "running total" option to choose from in the "all" section of the property sheet. I can not find where I have that option.

I am not very good at building expressions and calculations, which I assume is where the problem lies. Any help would be great. From posts I have read, it appears others have had the same problem. Thanks

[June7]

Running Sum is a property of textbox on a report, not available on a form. Showing a running sum on form is not easy. Can easily do the following:

Do not use the Sum function for Balance calculation in Detail section.
Is the form in Datasheet view? Click the Totals button from Home > Records. This will open a row where you can select aggregate functions.
If the form is not in Datasheet, put the Sum calculation in a textbox in Form header or footer section.

[bka57]

my "balance" calculation is in a text box of the "detail" section located under the form header when I pull up the "design" view. I see where you are speaking of the totals button for my records. From what I can see, this adds up all amounts in the deposit column and all amounts in the withdrawal column but does not effect the "balance" column.

Somehow, I would think that I have to reference the previous transaction "balance" then add the current transaction "depositamount", if any, and subtract the current transaction "withdrawalamount" if any. Similar to how you set up a formula in a spreadsheet.

ANy other thoughts are welcome

[June7]

Interesting, I really haven't used the Totals on a datasheet form before so just tested it. The expression in the Balance textbox results in a string value, not a number and the Totals row offers only None or Count as available, even after I set the textbox format to General Number. As I said, not easy to accomplish on form. This link shows method to calculate between records http://allenbrowne.com/subquery-01.html#AnotherRecord