Running Total Question

[Bob]

I have a Running Total next to each months Invoice total in a Sub Form, But
it only Calculates what Months I show on the form disregarding any totals
previous, Is it possible it can pick up previous total and add it in
Thanx for any Help ..............Bob







..........Jenny Vance

 

[Allen Browne]

If you want to show a total of all records in the table, regardles of how
the form is filtered, use a DSum() expression to get the total from the
table.

The Control Source of the text box will be something like this:
=DSum("Amount", "Table1")

Or, if you need to limit it to the total for the client in the form, add
criteria as well. Perhaps:
=DSum("Amount", "Table1", "ClientID = " & Nz([ClientID],0))