Running Total Question

  • Thread starter Thread starter Bob
  • Start date Start date
B

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
 
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))
 
Back
Top