Running total as records are added?

[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

 

[Wayne Morgan]

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.