sum of all records

[Guest]

I have a text box on a form that calculates the balance owed by a client. It
is an unbound text box with an expression in it. Is there a way to force the
result of the calculation into a field on the table so I can get a grand
total of all the balances owed from all records on the table?

 

[Guest]

To get a Sum of one field in the table you can use

=Dsum("[FieldName]","[TableName]")

To get a a sum of calculation, you can use

Dsum("[Field1Name]-[Field2Name]","TableName")

** There is no need to store a calculation in the table, you can always get
the same resault using a query