Running total as records are added?

  • Thread starter Thread starter James T.
  • Start date Start date
J

James T.

Using Access 2000.

In a form where the fields are fixed, say 10 records, and
I want to do a total I use:

=nz([Amount1])+nz([Amount2])+nz([Amount3]) .....

In a form where the user is adding new records with
different dollar amounts in each record, how do I get a
current running total as new records are added?

Thanks for any help,

James
 
You could use the DSum function to get the total of a field in the
underlying table. This won't show a change until the change has been written
to the table.
 
Back
Top