sum of all records

R

robertm600635

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?
 
O

Ofer Cohen

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cumulative formula for word table 0
do not display records on report based on value from calculated fi 2
Creating a Search using a combo box and then creating a report. 4
numerical summation to passed from sub to main form 2
Subform Calculated Field Used on Main Form to Sort Records 1
Word OLE to check spelling in text box 1
OLE Word spelling 0
Adding data to MS Access from csv file 0

Top