Sum from Table

[Wes]

Hello. I am creating a database to track a bank balance.

I have a table called BankingMain, where I put all deposits in one
column, and withdraws in another column.

I have several forms where I would like to display the working balance
in my account. The problem I am finding is that it will only let me
sum the amounts on the page. I have several filters that apply
depending upon my selections.

Is there a way I can get a text box on the footer of my form to give
me a running balance by summing all the withdraws and subtracting them
from the sum of all deposits from my BankingMain table?

Thanks for the help.

 

[Marshall Barton]

Hello. I am creating a database to track a bank balance.

I have a table called BankingMain, where I put all deposits in one
column, and withdraws in another column.

I have several forms where I would like to display the working balance
in my account. The problem I am finding is that it will only let me
sum the amounts on the page. I have several filters that apply
depending upon my selections.

Is there a way I can get a text box on the footer of my form to give
me a running balance by summing all the withdraws and subtracting them
from the sum of all deposits from my BankingMain table?

=DSum("deposits","BankingMain")-DSum("withdraws","BankingMain")

 

[Marshall Barton]

=DSum("deposits","BankingMain")-DSum("withdraws","BankingMain")

Please keep the correspondence in the newsgroups where
others can find answers to similar questions.

What error are you getting?

Also post a Copy/Paste of the expression that you used along
with the exact name of the table and the two fields of
interest.